[
https://issues.apache.org/jira/browse/DRILL-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti updated DRILL-1015:
-----------------------------------
Attachment: DRILL-1015-1.patch.txt
Currently compound identifiers are converted in DrillSqlWorker after parsing
the query, but when views are expanded, we don't apply the conversion process
as the view expander code is in Optiq. Fix is to move the conversion process to
Sql parser it self, so that whenever a query string is parsed output SqlNode
will have compound identifiers converted.
> Querying views from schema-less files is failing
> ------------------------------------------------
>
> Key: DRILL-1015
> URL: https://issues.apache.org/jira/browse/DRILL-1015
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser, Storage - JSON, Storage - Text & CSV
> Reporter: Rahul Challapalli
> Assignee: Venki Korukanti
> Priority: Blocker
> Attachments: DRILL-1015-1.patch.txt, nation.tbl, views.log
>
>
> git.commit.id.abbrev=894037a
> Querying a view which is created on top of schemaless files is failing with
> SqlValidatorException:[ Table 'columns' not found ]" error. Attached the
> relevant log file and the data file
> Below is the query that I executed.
> The folder referenced in the below query contains a 'nation.tbl' file
> CREATE VIEW nation AS SELECT
> cast(columns[0] AS int) n_nationkey,
> cast(columns[1] AS CHAR(25)) n_name,
> cast(columns[2] AS INT) n_regionkey,
> cast(columns[3] AS VARCHAR(152)) n_comment
> FROM dfs.`/drill/testdata/nation`;
> select count(*) from nation;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
