Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

I have exported a table from a Teradata DB to an orc file and uploaded to Hadoop. I can see the file in Hive but I can not use it as table. Is there any way to Hive see this orc file as a table?

I have exported a table from a Teradata DB to an orc file and uploaded to Hadoop. I can see the file in Hive but I can not use it as table. Is there any way to Hive see this orc file as a table?

New Contributor
 
1 REPLY 1

Re: I have exported a table from a Teradata DB to an orc file and uploaded to Hadoop. I can see the file in Hive but I can not use it as table. Is there any way to Hive see this orc file as a table?

New Contributor
You can't load file into RC table directly. In order to load a file into RC Hive table first import the data from Teradata to temp table/Normal Hive table which stores as text and then insert into your actual RCTable using

INSERT OVERWRITE INTO RCTABLE select * from temp;
Don't have an account?
Coming from Hortonworks? Activate your account here