Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.0
-
None
-
None
-
Fairly old CDH 4 VM.
Description
Here's an error I got running a join query against tables with different VARCHAR lengths. Here's the repro info:
[localhost:21000] > create table varchar_1 (s varchar(1));
[localhost:21000] > create table varchar_4 (s varchar(4));
[localhost:21000] > create table varchar_20 (s varchar(20));
[localhost:21000] > insert into varchar_1 values (cast('a' as varchar(1))), (cast('b' as varchar(1))), (cast('hello' as varchar(1))), (cast('world' as varchar(1)));
[localhost:21000] > insert into varchar_4 values (cast('a' as varchar(4))), (cast('b' as varchar(4))), (cast('hello' as varchar(4))), (cast('world' as varchar(4)));
[localhost:21000] > insert into varchar_20 values (cast('a' as varchar(20))), (cast('b' as varchar(20))), (cast('hello' as varchar(20))), (cast('world' as varchar(20)));
[localhost:21000] > select * from varchar_1;
---
s |
---
a |
b |
h |
w |
---
[localhost:21000] > select * from varchar_4;
------
s |
------
a |
b |
hell |
worl |
------
[localhost:21000] > select * from varchar_20;
-------
s |
-------
a |
b |
hello |
world |
-------
[localhost:21000] > select s from varchar_1 join varchar_20 using (s);
ERROR: AnalysisException: unqualified column reference 's' is ambiguous
[localhost:21000] > select varchar_1.s from varchar_1 join varchar_20 using (s);
Error communicating with impalad: TSocket read 0 bytes
select version();
----------------------------------------------------------------------------------------------
version() |
----------------------------------------------------------------------------------------------
impalad version 2.1.0-cdh4-INTERNAL RELEASE (build ba60a3584318d5c65ca12c25f5c9285bba7ec966) |
Built on Sat, 27 Sep 2014 11:06:20 PST |
----------------------------------------------------------------------------------------------