https://community.cloudera.com/t5/Support-Questions/Unable-to-import-data-into-hbase-table-through-Importtsv/m-p/141639#M104232 <P>Hi, I am using Apache Hbase (Version 1.1.3).</P><P>Sample data used: </P><P>simple structure that I have got for an industrial sensor </P><PRE> id, temp:in,temp:out,vibration,pressure:in,pressure:out 5842,50,30,4,240,340</PRE><P> executed the Loadtsv statement as following </P><PRE>hbase&gt; hbase org.apache.hadoop.hbase.mapreduce.ImportTsv-Dimporttsv.separator=,-Dimporttsv.columns="HBASE_ROW_KEY,id,temp:in,temp:out,vibration,pressure:in,pressure:out" sensor /user/hbase.csv</PRE><P> import the same data (header removed) - got this error - syntax error, unexpected ',' </P><P>then removed the 'ID' column in '-Dimporttsv.columns' </P><P>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 </P><P>getting </P><P>syntax error, unexpected tIDENTIFIER </P><P>Please help</P><P> Thanks, Sridharan</P> Thu, 16 Jun 2016 10:01:30 GMT shree20in 2016-06-16T10:01:30Z