[jira] [Created] (DRILL-1294) Columns of views created from files are of data type 'ANY'

["Norris Lee (JIRA)" <ji...@apache.org>]

Norris Lee created DRILL-1294:
---------------------------------

             Summary: Columns of views created from files are of data type 'ANY'
                 Key: DRILL-1294
                 URL: https://issues.apache.org/jira/browse/DRILL-1294
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Norris Lee


When you execute a select * query against a view created from a file (eg. from JSON or CSV), the data type of the columns returned reflect the nature of the data in the column (varchar, bigint, etc).
But in INFORMATION_SCHEMA.COLUMNS, the data type is listed as 'ANY'.


Note that if it was casted during the create view statement, then INFORMATION_SCHEMA.COLUMNS will display it correctly as whatever it was casted to.



--
This message was sent by Atlassian JIRA
(v6.2#6252)