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

MetadataOp.getTypeInfo() does not return all supported types

    XMLWordPrintableJSON

    Details

      Description

      The MetadataOp.getTypeInfo() does not return all the supported types. It's missing all the complex types (ARRAY, MAP, and STRUCT)  added in CDH5.5. Several of the primitive data types such as CHAR, VARCHAR, DECIMAL are also not being returned. Also, the newly added DATE type is not being returned.

      There is also a testing gap and ideally whenever a new type is added or support for a type is changed the MetadataOp.getTypeInfo() should return the correct result set representing the supported types.

      The Impala JDBC client should in theory call MetadataOp.getTypeInfo() but that is not happening in the latest version of the code. This Jira will only ensure that on Impala side the MetadataOp.getTypeInfo() returns correct results.

       

      <Old Description>

      Missing datatypes from JDBC DBMD.getTypeInfo() call:

      Filing this here since it seems to be an Impala defect as opposed to a driver defect based on observed behavior. The following is seen from DBMD.getTypeInfo() call against Hive:

      VOID 
      BOOLEAN 
      TINYINT 
      SMALLINT 
      INT 
      BIGINT 
      FLOAT 
      DOUBLE 
      STRING 
      CHAR 
      VARCHAR 
      DATE 
      TIMESTAMP 
      BINARY 
      DECIMAL 
      ARRAY 
      MAP 
      STRUCT 
      UNIONTYPE 
      USER_DEFINED

      And against Impala (2.1):

      NULL_TYPE 
      BOOLEAN 
      TINYINT 
      SMALLINT 
      INT 
      BIGINT 
      FLOAT 
      DOUBLE 
      TIMESTAMP 
      STRING 
      BINARY

      Note the missing newer datatypes (e.g. decimal, varchar).

      This is with the Hive 0.13 driver. Please let me know if there's something I'm missing and this should be filed against the driver.

      </Old Description>

        Attachments

          Activity

            People

            • Assignee:
              arawat Abhishek Rawat
              Reporter:
              jseidman_impala_e20b Jonathan Seidman
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: