Hive table in power bi

drgenious — Fri, 10 Dec 2021 10:55:47 GMT

Hi,

I want to create a hive table which will store data with orc format and snappy compression. Will power bi be able to read from that table? Also do you suggest any other format/compression for my table?

Re: Hive table in power bi

Shifu — Sun, 09 Jan 2022 03:17:09 GMT

Can you take a look at the below links for creating the ORC table with the Snappy compression question?

https://community.cloudera.com/t5/Support-Questions/Data-Compression-Doesn-t-work-in-ORC-with-SNAPPY-Compression/td-p/172151

https://community.cloudera.com/t5/Support-Questions/Snappy-vs-Zlib-Pros-and-Cons-for-each-compression-in-Hive/m-p/97110

https://community.cloudera.com/t5/Community-Articles/Performance-Comparison-b-w-ORC-SNAPPY-and-ZLib-in-hive-ORC/ta-p/246948

question Hive table in power bi in Support Questions

Hive table in power bi

Re: Hive table in power bi