question Re: Partitioning in Impala in Archives of Support Questions (Read Only)

Partitioning in Impala

manuel.lamelas — Fri, 16 Sep 2022 08:47:48 GMT

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

Re: Partitioning in Impala

alex.behm — Wed, 16 Oct 2013 18:55:30 GMT

This is known issue. Sorry.

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

Re: Partitioning in Impala

ZachRoes — Wed, 18 Jan 2017 01:23:43 GMT

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.