Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Hive external table on Hadoop archive files

Expert Contributor

Hi,

I created an external table on HAR files but i'm not able to see meaningful records. Is this supported in Hive and what SerDe should be used? I currently run HDP 2.6

1 REPLY 1

Hello @Joshua Adeleke!
I'm not used to HAR files + Hive, but did you set the following parameters?

hive> set hive.archive.enabled=true;
hive> set hive.archive.har.parentdir.settable=true;
hive> set har.partfile.size=1099511627776;
hive> msck repair table <EXTERNAL TABLE>;
Hope this helps!