[
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
