drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathy Qiu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3401) How to use Snappy compression on Parquet table?
Date Fri, 26 Jun 2015 19:55:04 GMT
Kathy Qiu created DRILL-3401:
--------------------------------

             Summary: How to use Snappy compression on Parquet table?
                 Key: DRILL-3401
                 URL: https://issues.apache.org/jira/browse/DRILL-3401
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.0.0
         Environment: Cloudera 5.4.2 AWS cluster
            Reporter: Kathy Qiu
            Assignee: Daniel Barclay (Drill)


To use Snappy compression on a Parquet table I created, these are the commands I used:

alter session set `store.format`='parquet';
alter session set `store.parquet.compression`='snappy';
create table <table_name> as (select 
cast (columns[0] as DECIMAL(10,0)) <column1_name>
etc...
from dfs.`<path to dataset>`);

Does this suffice? Or do I need to specify Snappy compression in the CTAS command as well?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message