Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21614

Derby does not support CLOB comparisons

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 2.3.4, 3.0.0
    • None
    • Metastore

    Description

      HiveMetaStoreClient.listTableNamesByFilter() with non empty filter causes exception with Derby DB:

      Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
      	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      	at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindComparisonOperator(Unknown Source)
      	at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(Unknown Source)
      	at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(Unknown Source)
      	at org.apache.derby.impl.sql.compile.BinaryLogicalOperatorNode.bindExpression(Unknown Source)
      	at org.apache.derby.impl.sql.compile.AndNode.bindExpression(Unknown Source)
      	at org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(Unknown Source)
      	at org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(Unknown Source)
      	at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
      	at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
      	at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
      	at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
      	at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
      	... 42 more
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              vrozov Vlad Rozov
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 50m
                  2h 50m