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

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

     [ https://issues.apache.org/jira/browse/TAJO-430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jaehwa Jung resolved TAJO-430.
------------------------------

    Resolution: Cannot Reproduce

We can't reproduce this issue any more.

> 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.5#6160)