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

Derby does not support CLOB comparisons

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.0.0, 2.3.4
    • Fix Version/s: None
    • Component/s: Metastore
    • Labels:
      None

      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

              • Assignee:
                Unassigned
                Reporter:
                vrozov Vlad Rozov
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: