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.

How do I create an ORC Hive table from Spark?

SOLVED Go to solution

Re: How do I create an ORC Hive table from Spark?

Rising Star

@Brandon Wilson I tried your suggestion it creates the hive table but I get this error:

org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter table.

and it does not load data into my table. do you have any idea how to solve this?

Re: How do I create an ORC Hive table from Spark?

Divya,

What is the user account when DF is used to create the external Hive table?

What is the user account when you try to see the table in Hive (& did you use HiveCli or Hive/Beeline or some ODBC tool?)

Highlighted

Re: How do I create an ORC Hive table from Spark?

Rising Star

@vshukla I am logging in as hdfs user on HDP 2.3.2 sandbox

and using the same account to see tables in hive.Yes , I am using hive CLI and even browsed HDFS files through Ambari .Couldnt see any tables created.