question Re: Missing back slashes in FIELD separator '\t' sample HIVE table creation in Archives of Support Questions (Read Only)

Missing back slashes in FIELD separator '\t' sample HIVE table creation

ldl — Thu, 02 Jun 2016 20:24:46 GMT

Tutorial should be fixed with the correct delimiter; i.e. '\t' instead of 't' for. (back slashes are missing causing bad import of sample files)

Example from tuto:

create table products (url STRING, category STRING) ROW FORMAT DELIMITED FIELDS TERMINATED by 't' stored as textfile tblproperties ("skip.header.line.count"="1");

Re: Missing back slashes in FIELD separator '\t' sample HIVE table creation

jyadav — Thu, 02 Jun 2016 20:27:16 GMT

Thanks @Laurent de Laprade

I will raise it to the Doc team.

http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/

Re: Missing back slashes in FIELD separator '\t' sample HIVE table creation

jyadav — Sat, 04 Jun 2016 23:47:56 GMT

@Laurent de Laprade

I have opened an internal Documentation bug for this and it will get fixed soon, Thanks for raising it.

Re: Missing back slashes in FIELD separator '\t' sample HIVE table creation

jbeckett — Thu, 13 Oct 2016 17:20:12 GMT

Four months? Perhaps you could give the Doc team a little nudge?

More generally, it's clear that HortonWorks have not checked these tutorials by having someone follow them through as written, perhaps that's something you should look at.