[jira] [Created] (TAJO-430) Sub-query can't handle null values well.

["JaeHwa Jung (JIRA)" <ji...@apache.org>]

JaeHwa Jung created TAJO-430:
--------------------------------

             Summary: Sub-query can't handle null values well.
                 Key: TAJO-430
                 URL: https://issues.apache.org/jira/browse/TAJO-430
             Project: Tajo
          Issue Type: Bug
            Reporter: JaeHwa Jung


I found a bug when I used sub-query which has null values as follows:

{code:title=table schema borderStyle=solid}
CREATE EXTERNAL TABLE table2 (id INT4, name TEXT, score FLOAT4, type TEXT) USING CSV WITH ('csvfile.delimiter'='|') LOCATION 'hdfs://localhost:9010/tajo/warehouse/table2'
{code}

{code:title=table data|borderStyle=solid}
1|aaa||a
2|bbb||b
|ccc|10.0|c
|ddd|20.0|d
{code}

{code:title=query1|borderStyle=solid}
tajo> select t.id, t.name from (select a.id, a.name from table2) t;
Some targets cannot be evaluated in the query block "t"
tajo> select t.id, t.name from (select a.id, a.name from table2 a) t;
Progress: 100%, response time: 0.58 sec
final state: QUERY_SUCCEEDED, response time: 0.58 sec
result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1387355494232_0066/RESULT, 4 rows (22 B)
id,  name
-------------------------------
1,  aaa
2,  bbb
null,  ccc
null,  ddd
{code}

{code:title=query2|borderStyle=solid}
tajo> select t.name, t.id from (select a.id, a.name from table2 a) t;
Query failed!
{code}

I just changed column order, but query failed to execute.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)