[
https://issues.apache.org/jira/browse/DRILL-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jinfeng Ni updated DRILL-2929:
------------------------------
Fix Version/s: (was: 1.2.0)
1.4.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.4.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)
