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.

Creating smaller table

Creating smaller table

New Contributor

Hi,

 

Sort of  newbie question. If I have a very large table in HIVE. How can I split that up into smaller tables, aggregate the data and then present that aggregated data into tableau. What is the best approach. Could i split the data needed from the large HIVE table and load it into impala? For faster search results of data ?

1 REPLY 1

Re: Creating smaller table

Contributor
I am not quite sure what the end goal is here but for hive tables that have vast amounts of data and if processing them is a concern, you could use partitions on the hive table. You could find some meaning way to divide the data into smaller files (example: by data or some range of values for columns etc).

Hope this helps.