Rahul Challapalli created DRILL-1015:
----------------------------------------
Summary: 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
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)
