Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to load tables from Hive to talend.

I have tried establishing a connection between hdfs & hive. Already loaded tables in hdfs... But when I am trying to load those same tables from hdfs to hive.. it is giving exception that those files not found in hdfs.... although they are present there...
(This is one of the job from Big Data demo project -- Hive Load tables.)
Labels (2)
5 Replies
Anonymous
Not applicable
Author

Hi,
I have tried establishing a connection between hdfs & hive. Already loaded tables in hdfs... But when I am trying to load those same tables from hdfs to hive.. it is giving exception that those files not found in hdfs.... although they are present there...
(This is one of the job from Big Data demo project -- Hive Load tables.)

1: Make sure there are files in HDF, indeed. You can use tHDFSinput-->tlogrow to read it or browser 50070 to check it.
2: What's your Hadoop version?
3: What's your load statement of hive?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi,
My files are already in hdfs.
Version : Hadoop 2.0.0-cdh4.4.0

My Hive load query is : "LOAD DATA INPATH '<hdfs path here>' OVERWRITE INTO TABLE <table name existing in hive>"
Anonymous
Not applicable
Author

Hi,
I have tried establishing a connection between hdfs & hive. Already loaded tables in hdfs... But when I am trying to load those same tables from hdfs to hive.. it is giving exception that those files not found in hdfs.... although they are present there...
(This is one of the job from Big Data demo project -- Hive Load tables.)

1: Make sure there are files in HDF, indeed. You can use tHDFSinput-->tlogrow to read it or browser 50070 to check it.
2: What's your Hadoop version?
3: What's your load statement of hive?
Best regards
Sabrina

Hi,
My files are already in hdfs.
Version : Hadoop 2.0.0-cdh4.4.0

My Hive load query is : "LOAD DATA INPATH '<hdfs path here>' OVERWRITE INTO TABLE <table name existing in hive>"
Anonymous
Not applicable
Author

Hi,
Do you use the embedded mode or the standalone mode for Hive?
Anonymous
Not applicable
Author

Hi,
Do you use the embedded mode or the standalone mode for Hive?

hi..
Its standalone..