[jira] [Commented] (DRILL-47) Generate Logical Plans for TPC-H Queries

["Sree Vaddi (JIRA)" <ji...@apache.org>]

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

Sree Vaddi commented on DRILL-47:
---------------------------------

Downloaded:
http://www.tpc.org/tpch/spec/tpch_2_16_0.zip

I created the pojo's for the schema (page 13) defined in tpch.2.16.0.pdf,
as a separate simple java project.
Then, used super-csv and gson libraries to convert the data files in psv (pipe separated value),
into JSON files.
Now, data is in json and schema as pojo's.

                
> Generate Logical Plans for TPC-H Queries
> ----------------------------------------
>
>                 Key: DRILL-47
>                 URL: https://issues.apache.org/jira/browse/DRILL-47
>             Project: Apache Drill
>          Issue Type: New Feature
>            Reporter: Jacques Nadeau
>            Assignee: Sree Vaddi
>
> Creating example logical plans should help in many ways.  Among those are validation cases for the sql parser, logical plan completeness, execution engine performance, etc.  It would be great if someone could generate logical plans for each of the TPC-H queries.
> The data is in PSV (pipe separated value) files.
> Converting these to JSON files.
> There are 20 sql files and 5 variant sql files.
> Creating one sub-task jira for each of the sql files.  Everything related to that sql will be in it, i.e. sql parser, logical plan, execution stats ...

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira