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.

Partitioning in Impala

Solved Go to solution
Highlighted

Partitioning in Impala

New Contributor

Hi,

 

I don't know if this is a bug, I've searched and didn't find anything.

 

Currently in hive it is not possible to create and upper level union all view:

 

CREATE VIEW as

select x from Y

UNION ALL

select x from Z

 

But you can have a work around

 

CREATE VIEW as

select * from (

select x from Y

UNION ALL

select x from Z) T

 

If you try it in Impala fails, with thrift exception. This is not important.

 

The importanT thing is that if Y and Z are partitioned, in Hive the view is partitioned too but in Impala it is not. It takes all the info.

 

Coluld somebody help me with this, is thera a work around??? Shoul I open bug????

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Partitioning in Impala

Master Collaborator

This is known issue. Sorry.

 

https://issues.cloudera.org/browse/IMPALA-593

2 REPLIES 2

Re: Partitioning in Impala

Master Collaborator

This is known issue. Sorry.

 

https://issues.cloudera.org/browse/IMPALA-593

Re: Partitioning in Impala

Cloudera Employee

In Impala, a table can be created by using the ‘CREATE Table’ command. Let us understand the general syntax of creating a table in Impala with the help of the commands shown on the screen. The ‘PARTITIONED BY’ clause partitions data files based on one or more specified columns values.