Partitioning in Impala

[#1]

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????

[#2 · Accepted solution]

This is known issue. Sorry.

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

[#3]

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.