Khurram Faraaz created DRILL-2929: ------------------------------------- Summary: 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: Jinfeng Ni
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)