[
https://issues.apache.org/jira/browse/HIVE-17557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Harleen Singh Mann updated HIVE-17557:
--------------------------------------
Description:
This works as excepted:
{color:green}create table t3(col1 Int, col2 String) stored as parquet
tblproperties ('PARQUET.COMPRESS'='SNAPPY');
insert into table t3 values (1,'one');
{color}
However the saved parquet file is not compressed in the below case:
{color:red}create table t2 stored as parquet
tblproperties('PARQUET.COMPRESS'='SNAPPY') as select * from t1;{color}
I am verifying the compression using "parquet-tools meta" command
was:
This works as excepted:
{color:red}create table t3(col1 Int, col2 String) stored as parquet
tblproperties ('PARQUET.COMPRESS'='SNAPPY');
{color}
However the saved parquet file is not compressed in the below case:
{color:red}create table t2 stored as parquet
tblproperties('PARQUET.COMPRESS'='SNAPPY') as select * from t1;{color}
I am verifying the compression using "parquet-tools meta" command
> Hive tblproperties "parquet.compress" not working when used with "As"
> statement
> -------------------------------------------------------------------------------
>
> Key: HIVE-17557
> URL: https://issues.apache.org/jira/browse/HIVE-17557
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Environment: CD-quickstart-vm-5.10.0-0-virtualbox
> Reporter: Harleen Singh Mann
>
> This works as excepted:
> {color:green}create table t3(col1 Int, col2 String) stored as parquet
> tblproperties ('PARQUET.COMPRESS'='SNAPPY');
> insert into table t3 values (1,'one');
> {color}
> However the saved parquet file is not compressed in the below case:
> {color:red}create table t2 stored as parquet
> tblproperties('PARQUET.COMPRESS'='SNAPPY') as select * from t1;{color}
> I am verifying the compression using "parquet-tools meta" command
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
