[
https://issues.apache.org/jira/browse/DRILL-47?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13739113#comment-13739113
]
Prafulla Tekawade commented on DRILL-47:
----------------------------------------
Hi Sree,
I would like to contribute to this issue. Can you please upload your json data
and DDLs to some repository at github?
I would try to generate plans/fix problem in other queries.
> 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.
> TPC-H Queries are in SQL. (not sure, if they use any ANSI SQL 2003 features ?)
> Use 'sqlparser' project to convert them in to respective logical plan in json
> format (json for now. any other formats we support now or in future ?)
> Use 'plan-parser' project to convert them into respective physical plan.
> (what is the output format(s) here for now and in future ?)
> Use 'ref' project to execute those physical plans. (how ?)
> DATA:
> The data is in PSV (pipe separated value) files.
> Converting these to JSON files.
> QUERIES:
> 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
