About Lucille

Lucille · ‎06-20-2016

thank you so much - this worked 🙂 I just have one more questions.. to get this into the another table - it doesn't seem to accept this.. what is wrong with it? It also did not like the <pre> bit... If I take it out, it runs.. create table tester ( SELECT hive_magnum.col1, hive_magnum.col2, hive_magnum.col3, hive_magnum.INPUT__FILE__NAME as file_name FROM hive_magnum)

Lucille · ‎06-13-2016

Hi guys, I am new to Cloudera and have only used Impala and Hive through Hue thus far. I have a folder of CSVs that I imported, but would like to add the filename as a column to each row that I import. How do I do this? I came across the function INPUT__FILE__NAME but I don't see it actually doing anything. My import is very easy - hoping you can help me? create external table hive_magnum ( col1 string, col2 string, col3 string ) row format delimited fields terminated by "," location '/user/xxxxxx/magnum';

Online	Offline
Last Visited	‎06-21-2016 06:22 AM

Member Since	‎06-01-2016 06:31 AM
Last Visited	‎06-21-2016 06:22 AM
Posts	6

Cloudera Community

Re: Add filename to import in Hive

Add filename to import in Hive