https://community.cloudera.com/t5/Archives-of-Support-Questions/The-tutorial-seems-to-be-outdated/m-p/166498#M45391 <P>Finally I was able to resolve the problem. Apart from different TSV filenames, the other major problem was with the Create Table (products and omniturelogs) commands. It used <U>FIELDS TERMINATED by 't'</U> which is <STRONG>incorrect</STRONG>. The <STRONG>correct </STRONG>expression is <STRONG>FIELDS TERMINATED by '\t'</STRONG> to indicate tab separated value.</P><P>Thanks</P><P>Anindya</P> Sat, 05 Nov 2016 20:04:54 GMT aschattopadhyay 2016-11-05T20:04:54Z https://community.cloudera.com/t5/Archives-of-Support-Questions/The-tutorial-seems-to-be-outdated/m-p/166497#M45390 <P><A href="http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/" target="_blank">http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/</A></P><P>Is this tutorial current? TSV filenames don't match. Also got trouble with importing the TSV files into table</P> Sat, 05 Nov 2016 17:51:54 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/The-tutorial-seems-to-be-outdated/m-p/166497#M45390 aschattopadhyay 2016-11-05T17:51:54Z https://community.cloudera.com/t5/Archives-of-Support-Questions/The-tutorial-seems-to-be-outdated/m-p/166498#M45391 <P>Finally I was able to resolve the problem. Apart from different TSV filenames, the other major problem was with the Create Table (products and omniturelogs) commands. It used <U>FIELDS TERMINATED by 't'</U> which is <STRONG>incorrect</STRONG>. The <STRONG>correct </STRONG>expression is <STRONG>FIELDS TERMINATED by '\t'</STRONG> to indicate tab separated value.</P><P>Thanks</P><P>Anindya</P> Sat, 05 Nov 2016 20:04:54 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/The-tutorial-seems-to-be-outdated/m-p/166498#M45391 aschattopadhyay 2016-11-05T20:04:54Z