Getting the below message as output hbase(main):003:0> hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=',' -Dimporttsv.columns='HBASE_ROW_KEY,temp:in,temp:out,vibration,pressure:in,pressure:out' t2 user/hbase.csv SyntaxError: (hbase):3: syntax error, unexpected tIDENTIFIER hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=',' -Dimporttsv.columns='HBASE_ROW_KEY,temp:in,temp:out,vibration,pressure:in,pressure:out' t2 user/hbase.csv ^ ... View more

Hi Ted, Thanks again for your help. I tried the same steps as you did again. But still no luck. I have a basic question. 'hbase.csv' is placed in hdfs in your case? I placed it in HDFS folder. Should that be placed in the hbase directory? Thanks, Sridharan ... View more

Hi Sunil and Ted, Thanks for your reply, I tried both your suggestions, but no luck hbase(main):008:0> hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=',' -Dimporttsv.columns='HBASE_ROW_KEY,temp:in,temp:out,vibration,pressure:in,pressure:out' sensor user/hbase.csv Getting SyntaxError: (hbase):8: syntax error, unexpected tIDENTIFIER The table structure is hbase(main):009:0> describe 'sensor' Table sensor is ENABLED sensor COLUMN FAMILIES DESCRIPTION {NAME => 'pressure', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_V ERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'} {NAME => 'temp', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_VERSI ONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'} {NAME => 'vibration', DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE', MIN_ VERSIONS => '0', TTL => 'FOREVER', KEEP_DELETED_CELLS => 'FALSE', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE => 'true'} Should anything be modified here? How to do that please? Thanks, Sridharan ... View more

Hi, I am using Apache Hbase (Version 1.1.3) I used the same importtsv syntax to import the same data (header removed) - got this error - syntax error, unexpected ',' then removed the 'ID' column in '-Dimporttsv.columns' hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator= ',' -Dimporttsv.columns="HBASE_ROW_KEY,temp:in,temp:out,vibration,pressure:in,pressure:out" sensor /user/hbase.csv getting syntax error, unexpected tIDENTIFIER Please help Thanks, Sridharan ... View more