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

Builds broken because test_exprs uses a reserved word

    Details

    • Target Version:
    • Epic Color:
      ghx-label-8

      Description

      See https://jenkins.impala.io/job/gerrit-verify-dryrun/1862/consoleFull

      19:59:35 ]  TestExprs.test_exprs[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none | enable_expr_rewrites: 0] 
      19:59:35 ] [gw5] linux2 -- Python 2.7.12 /home/ubuntu/Impala/bin/../infra/python/env/bin/python
      19:59:35 ] query_test/test_exprs.py:58: in test_exprs
      19:59:35 ]     self.run_test_case('QueryTest/exprs', vector)
      19:59:35 ] common/impala_test_suite.py:397: in run_test_case
      19:59:35 ]     result = self.__execute_query(target_impalad_client, query, user=user)
      19:59:35 ] common/impala_test_suite.py:612: in __execute_query
      19:59:35 ]     return impalad_client.execute(query, user=user)
      19:59:35 ] common/impala_connection.py:160: in execute
      19:59:35 ]     return self.__beeswax_client.execute(sql_stmt, user=user)
      19:59:35 ] beeswax/impala_beeswax.py:173: in execute
      19:59:35 ]     handle = self.__execute_query(query_string.strip(), user=user)
      19:59:35 ] beeswax/impala_beeswax.py:339: in __execute_query
      19:59:35 ]     handle = self.execute_query_async(query_string, user=user)
      19:59:35 ] beeswax/impala_beeswax.py:335: in execute_query_async
      19:59:35 ]     return self.__do_rpc(lambda: self.imp_service.query(query,))
      19:59:35 ] beeswax/impala_beeswax.py:460: in __do_rpc
      19:59:35 ]     raise ImpalaBeeswaxException(self.__build_error_message(b), b)
      19:59:35 ] E   ImpalaBeeswaxException: ImpalaBeeswaxException:
      19:59:35 ] E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
      19:59:35 ] E    MESSAGE: AnalysisException: Syntax error in line 2:
      19:59:35 ] E   tmp.pattern, tmp.index) from (values
      19:59:35 ] E       ^
      19:59:35 ] E   Encountered: A reserved word cannot be used as an identifier: pattern
      19:59:35 ] E   Expected: DEFAULT, IDENTIFIER
      19:59:35 ] E   
      19:59:35 ] E   CAUSED BY: Exception: Syntax error
      ....
      
      19:59:35 ] -- executing against localhost:21000
      19:59:35 ] select regexp_extract(regexp_escape(tmp.str),
      19:59:35 ] tmp.pattern, tmp.index) from (values
      19:59:35 ] ('Hello\\world' as str, '([[:alpha:]]+)(\\\\\\\\)([[:alpha:]]+)' as pattern, 2 as index)
      19:59:35 ] ) as tmp;
      

        Attachments

          Activity

            People

            • Assignee:
              tianyiwang Tianyi Wang
              Reporter:
              tarmstrong Tim Armstrong
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: