[jira] [Created] (DRILL-677) INFORMATION_SCHEMA.COLUMNS table lists nullable columns as non-nullable

[Rahul Challapalli (JIRA)]

Rahul Challapalli created DRILL-677:
---------------------------------------

             Summary: INFORMATION_SCHEMA.COLUMNS  table lists nullable columns 
as non-nullable
                 Key: DRILL-677
                 URL: https://issues.apache.org/jira/browse/DRILL-677
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Rahul Challapalli


1. create hive table ( these columns are nullable)
hive> DROP TABLE IF EXISTS STUDENTS;
CREATE EXTERNAL TABLE STUDENTS
(
    ID VARCHAR(24),
    NAME VARCHAR(24),
    STREET VARCHAR(256),
    ZIPCODE INT,
    STATE VARCHAR(20)
)
ROW FORMAT DELIMITED FIELDS
TERMINATED BY ','
STORED AS TEXTFILE LOCATION "/drill/testdata/information-schema/students/";

2. From drill issue the below query and check the 'IS_NULLABLE" column

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='hive' AND 
TABLE_NAME='students';




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