Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-1316

impalad crash on VARCHAR query

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • Impala 2.0
    • 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

      ----------------------------------------------------------------------------------------------

      Attachments

        Activity

          People

            victor.bittorf_impala_fcb6 Victor Bittorf
            jrussell John Russell
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: