Fine. Then an option would be using CsvBulkloadTool to directely loading data to phoenix.
Thanks, Sun. CertusNet From: Thanaphol Prasitphaithoon Date: 2015-01-29 17:02 To: [email protected] CC: user Subject: Re: Integer record change when I create table from Phoenix to hbase If I declare column as varchar, I cannot use sum functions in phoenix. I want to use this function in some case. On Thu, Jan 29, 2015 at 3:52 PM, [email protected] <[email protected]> wrote: Hi, For your use case, I think one of the possible solution could be declaring your column as varchar. Newbie with sqoop and not sure whether sqoop uses hbase native api (put, etc.) to load data into hbase. If so, I think that would not get the right integer value through phoenix query. Thanks, Sun. CertusNet From: thanaphol Date: 2015-01-29 15:47 To: [email protected] Subject: Integer record change when I create table from Phoenix to hbase Hi guys, I have problem about integer record from hbase table. I create table from phoenix to hbase cluster with UNSIGNED_TINYINT for integer column and I use sqoop to import records from RDBMS to hbase but when I view record from phoenix I see different number between phoenix and hbase. Example: I import "1" Integer from RDBMS to HBASE. I scan record in HBASE. I still see "1". I select * from phoenix table. I see "49". RDBMS HBASE PHOENIX 1 => 1 => 49 It like hbase collect record as string. When I set datatype = Integer in phoenix table ,Phoenix will convert String to Integer. What are your suggest me to do for this problem? Thank you -- Best Regards, Thanaphol Prasitphaithoon ========================= Information Security Engineer Service Department Mindterra Company Limited Tel: (+66) 2530 2062-4 Fax: (+66) 2530 2177 Mobile: (+66) 84-022-0683 E-mail: [email protected] Website: http://www.mindterra.com Interact Mindterra via Facebook and Twitter
