Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Error while loading data into Hbase table

Solved Go to solution
Highlighted

Error while loading data into Hbase table

Rising Star

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Error while loading data into Hbase table

Explorer

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

View solution in original post

3 REPLIES 3
Highlighted

Re: Error while loading data into Hbase table

Explorer

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

Highlighted

Re: Error while loading data into Hbase table

Explorer

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

View solution in original post

Highlighted

Re: Error while loading data into Hbase table

Rising Star

@mhegedus thank you very much :)

Don't have an account?
Coming from Hortonworks? Activate your account here