Error while loading data into Hbase table

[#1]

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?

[#2]

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

[#3 · Accepted solution]

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

[#4]

@mhegedus thank you very much 🙂