sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pratik Khadloya (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-1390) Import data to HDFS as a set of Parquet files
Date Sun, 02 Nov 2014 18:50:34 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-1390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14193954#comment-14193954
] 

Pratik Khadloya commented on SQOOP-1390:
----------------------------------------

You might need the right version of the kite sdk. If you build sqoop using
the ant command, you will get the correct kite libs in the build/lib
generated directory which can be copied to sqoop/lib.

Sample command:
bin/sqoop import -libjars
build/sqoop-1.4.6-SNAPSHOT.bin__hadoop-2.0.4-alpha/lib/kite-data-core-0.15.0.jar,build/sqoop-1.4.6-SNAPSHOT.bin__hadoop-2.0.4-alpha/lib/kite-data-mapreduce-0.15.0.jar
-jt <your-jobtracker>:8021 --connect jdbc:mysql://<yourdburl> --username
<user> --password <pwd> --as-parquetfile --table <table> --where
<where-clause> --target-dir <hdfs-dir>





> Import data to HDFS as a set of Parquet files
> ---------------------------------------------
>
>                 Key: SQOOP-1390
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1390
>             Project: Sqoop
>          Issue Type: Sub-task
>          Components: tools
>            Reporter: Qian Xu
>            Assignee: Qian Xu
>             Fix For: 1.4.6
>
>         Attachments: SQOOP-1390.patch
>
>
> Parquet files keep data in contiguous chunks by column, appending new records to a dataset
requires rewriting substantial portions of existing a file or buffering records to create
a new file. 
> The JIRA proposes to add the possibility to import an individual table from a RDBMS into
HDFS as a set of Parquet files. We will also provide a command-line interface with a new argument
{{--as-parquetfile}} 
> Example invocation: 
> {{sqoop import --connect JDBC_URI --table TABLE --as-parquetfile --target-dir /path/to/files}}
> The major items are listed as follows:
> * Implement ParquetImportMapper
> * Hook up the ParquetOutputFormat and ParquetImportMapper in the import job.
> * Be able to support import from scratch or in append mode
> Note that as Parquet is a columnar storage format, it doesn't make sense to write to
it directly from record-based tools. So we'd consider to use Kite SDK to simplify the handling
of Parquet specific things.



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

Mime
View raw message