Reply
New Contributor
Posts: 3
Registered: ‎09-10-2013
Accepted Solution

Partitioning in Impala

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

Cloudera Employee
Posts: 307
Registered: ‎10-16-2013

Re: Partitioning in Impala

This is known issue. Sorry.

 

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

Cloudera Employee
Posts: 20
Registered: ‎01-17-2017

Re: Partitioning in Impala

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.