Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Partitioning in Impala

avatar
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

avatar
2 REPLIES 2

avatar

This is known issue. Sorry.

 

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

avatar
Contributor

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.