[
https://issues.apache.org/jira/browse/DRILL-469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13954313#comment-13954313
]
B Anil Kumar edited comment on DRILL-469 at 3/29/14 4:03 PM:
-------------------------------------------------------------
Tested with following hive table with following data.
Sample data:
{quote}
NULL,null,48,3.9867,166679572691
NULL,,48,3.9867,166679572691
1,2,,,78
NULL,null,48,3.9867,test1
NULL,,48,3.9867,test2
1,2,,,test3
1,2,3,4.5,test5
{quote}
Hive Table:
{quote}
hive> describe drill_test3;
OK
c1 int None
c2 bigint None
c3 int None
c4 float None
c5 string None
Time taken: 0.267 seconds, Fetched: 5 row(s)
hive> select * from drill_test3;
OK
NULL NULL 48 3.9867 166679572691
NULL NULL 48 3.9867 166679572691
1 2 NULL NULL 78
NULL NULL 48 3.9867 test1
NULL NULL 48 3.9867 test2
1 2 NULL NULL test3
1 2 3 4.5 test5
Time taken: 0.188 seconds, Fetched: 7 row(s)
{quote}
Sqlline results:
{quote}
0: jdbc:drill:zk=local> select * from hive.drill_test3;
+------------+------------+------------+------------+------------+
| c1 | c2 | c3 | c4 | c5 |
+------------+------------+------------+------------+------------+
| null | null | 48 | 3.9867 | 166679572691 |
| null | null | 48 | 3.9867 | 166679572691 |
| 1 | 2 | null | null | 78 |
| null | null | 48 | 3.9867 | test1 |
| null | null | 48 | 3.9867 | test2 |
| 1 | 2 | null | null | test3 |
| 1 | 2 | 3 | 4.5 | test5 |
+------------+------------+------------+------------+------------+
7 rows selected (1.299 seconds)
0: jdbc:drill:zk=local>
{quote}
was (Author: akumarb2010):
Tested with following hive table by following data.
Sample data:
{quote}
NULL,null,48,3.9867,166679572691
NULL,,48,3.9867,166679572691
1,2,,,78
NULL,null,48,3.9867,test1
NULL,,48,3.9867,test2
1,2,,,test3
1,2,3,4.5,test5
{quote}
Hive Table:
{quote}
hive> describe drill_test3;
OK
c1 int None
c2 bigint None
c3 int None
c4 float None
c5 string None
Time taken: 0.267 seconds, Fetched: 5 row(s)
hive> select * from drill_test3;
OK
NULL NULL 48 3.9867 166679572691
NULL NULL 48 3.9867 166679572691
1 2 NULL NULL 78
NULL NULL 48 3.9867 test1
NULL NULL 48 3.9867 test2
1 2 NULL NULL test3
1 2 3 4.5 test5
Time taken: 0.188 seconds, Fetched: 7 row(s)
{quote}
Sqlline results:
{quote}
0: jdbc:drill:zk=local> select * from hive.drill_test3;
+------------+------------+------------+------------+------------+
| c1 | c2 | c3 | c4 | c5 |
+------------+------------+------------+------------+------------+
| null | null | 48 | 3.9867 | 166679572691 |
| null | null | 48 | 3.9867 | 166679572691 |
| 1 | 2 | null | null | 78 |
| null | null | 48 | 3.9867 | test1 |
| null | null | 48 | 3.9867 | test2 |
| 1 | 2 | null | null | test3 |
| 1 | 2 | 3 | 4.5 | test5 |
+------------+------------+------------+------------+------------+
7 rows selected (1.299 seconds)
0: jdbc:drill:zk=local>
{quote}
> Querying Hive tables containing null values fails
> -------------------------------------------------
>
> Key: DRILL-469
> URL: https://issues.apache.org/jira/browse/DRILL-469
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ramana Inukonda Nagaraj
> Attachments: DRILL-469.1.patch.txt
>
>
> 0: jdbc:drill:> select * from hive.student;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "de02259f-865a-42df-97ff-f34305af922b"
> endpoint {
> address: "perfnode166.perf.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < NullPointerException"
> ]
> Error: exception while executing query (state=,code=0)
> Offending row:
> NULL null 48 3.9867 166679572691
> NULL is specified for column of type INT(in both hive and drill)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
