[IMPALA-11156] TestHmsIntegration.test_desc_json_table failed in exhaustive build

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0
• Fix Version/s: Impala 4.1.0
• Component/s: Infrastructure
• Labels: build-failure
• Epic Color: ghx-label-11
• Assignee: Pranav Yogi Lodha
• Reporter: Riza Suminto
• Created: 01/Mar/22 06:13
• Updated: 11/Mar/22 10:37
• Resolved: 11/Mar/22 10:37

Description

TestHmsIntegration.test_desc_json_table failed in exhaustive test with the following errors:

metadata/test_hms_integration.py:684: in test_desc_json_table
    expected = self.client.execute('DESC %s' % table_name)
common/impala_connection.py:212: in execute
    return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:189: in execute
    handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:365: in __execute_query
    handle = self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:359: in execute_query_async
    handle = self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:522: in __do_rpc
    raise ImpalaBeeswaxException(self.__build_error_message(b), b)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
E    MESSAGE: ParseException: Syntax error in line 1:
E   DESC lyfduervsoypyviw.gfmldijspymuyeaz
E   ^
E   Encountered: DESC
E   Expected: ALTER, COMMENT, COMPUTE, COPY, CREATE, DELETE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, UPDATE, UPSERT, USE, VALUES, WITH
E   
E   CAUSED BY: Exception: Syntax error 

This can be reproduced consistently with following command

impala-py.test --exploration=exhaustive tests/metadata/test_hms_integration.py::TestHmsIntegration::test_desc_json_table 

It looks like the intended command should be DESCRIBE instead of DESC.

Issue Links

• is caused by: IMPALA-11112 Impala can't resolve json tables created by Hive