Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 3.0
-
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;