You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Prafulla Tekawade (JIRA)" <ji...@apache.org> on 2013/08/14 03:17:47 UTC
[jira] [Commented] (DRILL-47) Generate Logical Plans for TPC-H
Queries
[ 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