Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) 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!
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.