Error while loading data into Hbase table

wael_horchani1 — Wed, 08 Feb 2017 23:30:02 GMT

Hello,

Trying to achieve LAB 4 in Hello World series, I'm facing following error when loading data into Hbase table

hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=, -Dimporttsv.columns="HBASE_ROW_KEY,events:driverId,events:driverName,events:eventTime,events:eventType,events:latitudeColumn,events:longitudeColumn,events:routeId,events:routeName,events:truckId" driver_dangerous_event hdfs://sandbox.hortonworks.com:/tmp/data.csv SyntaxError: (hbase):8: syntax error, unexpected ',' hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=, -Dimporttsv.columns="HBASE_ROW_KEY,events:driverId,events:driverName,events:eventTime,events:eventType,events:latitudeColumn,events:longitudeColumn,events:routeId,events:routeName,events:truckId" driver_dangerous_event hdfs://sandbox.hortonworks.com:/tmp/data.csv ^

It looks that it does'nt accept the separator syntax!! any idea please?

Re: Error while loading data into Hbase table

jgub — Wed, 08 Feb 2017 23:37:05 GMT

Could you please try putting the separator inside double quotes? Like -Dimporttsv.separator=","

Re: Error while loading data into Hbase table

mhegedus — Wed, 08 Feb 2017 23:54:19 GMT

Execute the import command from bash. Seems like you were in hbase shell.

Re: Error while loading data into Hbase table

wael_horchani1 — Thu, 09 Feb 2017 05:25:54 GMT

@mhegedus thank you very much 🙂

question Re: Error while loading data into Hbase table in Archives of Support Questions (Read Only)

Error while loading data into Hbase table

Re: Error while loading data into Hbase table

Re: Error while loading data into Hbase table

Re: Error while loading data into Hbase table