04-17-2017 05:00 AM
Note : As my client standards I have to use only c- cedilla as a delimiter .
I created a sqoop command with c-cedilla as a delimiters.This is successfully worked. Now my data contains fields which is separted by c-cedilla .
Next step i created the Hive table with c-cedila as field delimiters (created c-cedilla by using octal representation "\307"of it.) , here the problem arises. whenever i am quering the table only NULL values is displayed.
Please assits on this.
Find the syntx below.
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\307'
STORED AS TEXTFILE
In some communities they states "Hive is not able to use ASCII characters , higher octal number than 177" is it so? please confirm on this.
and also there is a ticket for other character , refer the link "https://issues.apache.org/jira/browse/HIVE-14334" .