[ 
https://issues.apache.org/jira/browse/IMPALA-8558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Knupp updated IMPALA-8558:
--------------------------------
    Description: 
This issue is showing up for databases functional, functional_parquet, and 
functional_orc_def. It's not immediately clear why this table wasn't created 
during data load. But for example:

*Stacktrace*
{noformat}
query_test/test_chars.py:75: in test_char_format
    self.run_test_case('QueryTest/chars-formats', vector)
common/impala_test_suite.py:512: in run_test_case
    result = self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:746: in __execute_query
    return impalad_client.execute(query, user=user)
common/impala_connection.py:180: in execute
    return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:187: in execute
    handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:362: in __execute_query
    handle = self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:356: in execute_query_async
    handle = self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:516: in __do_rpc
    raise ImpalaBeeswaxException(self.__build_error_message(b), b)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
E    MESSAGE: AnalysisException: Could not resolve table reference: 
'chars_formats'
{noformat}

*Standard Error*
{noformat}
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
-- connecting to: node-4.foo.mycompany.com:21000
-- connecting to node-4.foo.mycompany.com:21050 with impyla
-- 2019-05-15 00:05:55,759 INFO     MainThread: Closing active operation
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
-- executing against node-4.foo.mycompany.com:21000
use functional;

-- 2019-05-15 00:05:55,788 INFO     MainThread: Started query 
f845123ce97ab647:0560abac00000000
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
SET batch_size=0;
SET num_nodes=0;
SET disable_codegen_rows_threshold=0;
SET disable_codegen=False;
SET abort_on_error=1;
SET exec_single_node_rows_threshold=0;
-- executing against node-4.foo.mycompany.com:21000
select * from chars_formats order by vc;
{noformat}

  was:
This issue is showing up for databases functional, functional_parquet, and 
functional_orc_def. It's not immediately clear why this table wasn't created 
during data load. But for example:

*Stacktrace*
{noformat}
query_test/test_chars.py:75: in test_char_format
    self.run_test_case('QueryTest/chars-formats', vector)
common/impala_test_suite.py:512: in run_test_case
    result = self.__execute_query(target_impalad_client, query, user=user)
common/impala_test_suite.py:746: in __execute_query
    return impalad_client.execute(query, user=user)
common/impala_connection.py:180: in execute
    return self.__beeswax_client.execute(sql_stmt, user=user)
beeswax/impala_beeswax.py:187: in execute
    handle = self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:362: in __execute_query
    handle = self.execute_query_async(query_string, user=user)
beeswax/impala_beeswax.py:356: in execute_query_async
    handle = self.__do_rpc(lambda: self.imp_service.query(query,))
beeswax/impala_beeswax.py:516: in __do_rpc
    raise ImpalaBeeswaxException(self.__build_error_message(b), b)
E   ImpalaBeeswaxException: ImpalaBeeswaxException:
E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
E    MESSAGE: AnalysisException: Could not resolve table reference: 
'chars_formats'
{noformat}

*Standard Error*
{noformat}
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
-- connecting to: quasar-nsgjqi-4.vpc.cloudera.com:21000
-- connecting to quasar-nsgjqi-4.vpc.cloudera.com:21050 with impyla
-- 2019-05-15 00:05:55,759 INFO     MainThread: Closing active operation
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
-- executing against quasar-nsgjqi-4.vpc.cloudera.com:21000
use functional;

-- 2019-05-15 00:05:55,788 INFO     MainThread: Started query 
f845123ce97ab647:0560abac00000000
SET 
client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
SET batch_size=0;
SET num_nodes=0;
SET disable_codegen_rows_threshold=0;
SET disable_codegen=False;
SET abort_on_error=1;
SET exec_single_node_rows_threshold=0;
-- executing against quasar-nsgjqi-4.vpc.cloudera.com:21000
select * from chars_formats order by vc;

{noformat}





> test_char_format failing on deployed clusters because chars_formats table 
> does not exist
> ----------------------------------------------------------------------------------------
>
>                 Key: IMPALA-8558
>                 URL: https://issues.apache.org/jira/browse/IMPALA-8558
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Infrastructure
>    Affects Versions: Impala 3.3.0
>            Reporter: David Knupp
>            Priority: Critical
>
> This issue is showing up for databases functional, functional_parquet, and 
> functional_orc_def. It's not immediately clear why this table wasn't created 
> during data load. But for example:
> *Stacktrace*
> {noformat}
> query_test/test_chars.py:75: in test_char_format
>     self.run_test_case('QueryTest/chars-formats', vector)
> common/impala_test_suite.py:512: in run_test_case
>     result = self.__execute_query(target_impalad_client, query, user=user)
> common/impala_test_suite.py:746: in __execute_query
>     return impalad_client.execute(query, user=user)
> common/impala_connection.py:180: in execute
>     return self.__beeswax_client.execute(sql_stmt, user=user)
> beeswax/impala_beeswax.py:187: in execute
>     handle = self.__execute_query(query_string.strip(), user=user)
> beeswax/impala_beeswax.py:362: in __execute_query
>     handle = self.execute_query_async(query_string, user=user)
> beeswax/impala_beeswax.py:356: in execute_query_async
>     handle = self.__do_rpc(lambda: self.imp_service.query(query,))
> beeswax/impala_beeswax.py:516: in __do_rpc
>     raise ImpalaBeeswaxException(self.__build_error_message(b), b)
> E   ImpalaBeeswaxException: ImpalaBeeswaxException:
> E    INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
> E    MESSAGE: AnalysisException: Could not resolve table reference: 
> 'chars_formats'
> {noformat}
> *Standard Error*
> {noformat}
> SET 
> client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
> -- connecting to: node-4.foo.mycompany.com:21000
> -- connecting to node-4.foo.mycompany.com:21050 with impyla
> -- 2019-05-15 00:05:55,759 INFO     MainThread: Closing active operation
> SET 
> client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
> -- executing against node-4.foo.mycompany.com:21000
> use functional;
> -- 2019-05-15 00:05:55,788 INFO     MainThread: Started query 
> f845123ce97ab647:0560abac00000000
> SET 
> client_identifier=query_test/test_chars.py::TestCharFormats::()::test_char_format[protocol:beeswax|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;
> SET batch_size=0;
> SET num_nodes=0;
> SET disable_codegen_rows_threshold=0;
> SET disable_codegen=False;
> SET abort_on_error=1;
> SET exec_single_node_rows_threshold=0;
> -- executing against node-4.foo.mycompany.com:21000
> select * from chars_formats order by vc;
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org

Reply via email to