drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Norris Lee (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1294) Columns of views created from files are of data type 'ANY'
Date Wed, 13 Aug 2014 16:38:14 GMT
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)

Mime
View raw message