drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2929) Join query does not return results/error/exception, appears to be hung
Date Tue, 16 Jun 2015 20:32:02 GMT

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

Aman Sinha updated DRILL-2929:
------------------------------
    Fix Version/s:     (was: 1.1.0)
                   1.2.0

> Join query does not return results/error/exception, appears to be hung
> ----------------------------------------------------------------------
>
>                 Key: DRILL-2929
>                 URL: https://issues.apache.org/jira/browse/DRILL-2929
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 0.9.0
>         Environment: f5b0f4928d9c8c47c145a179c52ba3933d85c0b4 | DRILL-1502: Can't connect
to mongo when requiring auth | 29.04.2015 @ 11:22:41 EDT | Unknown     | 29.04.2015 @ 14:44:10
EDT |
>            Reporter: Khurram Faraaz
>            Assignee: Sean Hsuan-Yi Chu
>             Fix For: 1.2.0
>
>
> multi way equi join query hangs on rpm version based on 29th. Explain plan does not return
anything, web UI shows query as PENDING state. Test was run on 4 node cluster on CentOS. There
are no errors/exceptions reported in drillbit.log
> Hanging query is,
> {code}
> 0: jdbc:drill:> select bi.columns[0], ci.columns[0], di.columns[0], fi.columns[0],
ini.columns[0], vi.columns[0]
> . . . . . . . > from `bgint_f.csv` bi,
> . . . . . . . > `char_f.csv` ci,
> . . . . . . . > `dbl_f.csv` di,
> . . . . . . . > `float_f.csv` fi,
> . . . . . . . > `int_f.csv` ini,
> . . . . . . . > `vchar_f.csv` vi
> . . . . . . . > where bi.columns[0] = ci.columns[0]
> . . . . . . . > and di.columns[0] = fi.columns[0]
> . . . . . . . > and ini.columns[0] = vi.columns[0]
> . . . . . . . > and ci.columns[0] = di.columns[0]
> . . . . . . . > and fi.columns[0] = ini.columns[0]
> . . . . . . . > and ci.columns[0] = ini.columns[0];
> {code}
> Data used in test is
> {code}
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/bgint_f.csv
> 1
> 2
> 0
> -1
> 1000000
> 65535
> 100
> 13
> 19
> 17
> 111111
> 1010101
> 9999999
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/char_f.csv
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 0
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/dbl_f.csv
> 123.45
> 11.98
> 12345.39
> 1.1
> 1.0
> 0.0
> -1.0
> 11111.99
> 99999.99
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/float_f.csv
> 1.1
> 1.234
> 1234.19
> 13.19
> 1.0
> -1.0
> 0.0
> 1111.98
> 9999.99
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/int_f.csv
> 1
> 0
> -1
> 65535
> 1234567
> 1000000
> 101010
> 11111
> 100
> 13
> 19
> 17
> [root@centos-04 join_hang]# hadoop fs -cat /tmp/vchar_f.csv
> 12345
> 1
> 0
> -1
> 200000
> 1000000
> 65535
> 13
> 19
> 17
> 11111
> 10101
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message