[jira] [Created] (DRILL-2929) Join query does not return results/error/exception, appears to be hung

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

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)