[ https://issues.apache.org/jira/browse/IMPALA-7939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuj Phadke updated IMPALA-7939: -------------------------------- Description: 1. [localhost:21000] > CREATE TABLE test (cp_master_id STRING, data_status STRING) stored as parquet; Query: CREATE TABLE test (cp_master_id STRING, data_status STRING) stored as parquet Fetched 0 row(s) in 0.03s 2. [localhost:21000] > insert into test (cp_master_id, data_status) values ('11111111111','NEWREC'); Query: insert into test (cp_master_id, data_status) values ('11111111111','NEWREC') Query submitted at: 2018-12-06 14:02:21 (Coordinator: [http://anuj-OptiPlex-9020:25000|http://anuj-optiplex-9020:25000/]) Query progress can be monitored at: [http://anuj-OptiPlex-9020:25000/query_plan?query_id=14182abf0a7e4bb:8788cdab00000000|http://anuj-optiplex-9020:25000/query_plan?query_id=14182abf0a7e4bb:8788cdab00000000] Modified 1 row(s) in 4.14s *********************************************************************************** 3. [localhost:21000] > WITH tbl_incoming > AS > ( > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR > data_status='UPDATE') > ) > select * from test; Query: WITH tbl_incoming AS ( SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE') ) select * from test Modified 0 row(s) in 0.12s [localhost:21000] > 4. [localhost:21000] > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE'); Query: SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE') Query submitted at: 2018-12-06 14:05:48 (Coordinator: [http://anuj-OptiPlex-9020:25000|http://anuj-optiplex-9020:25000/]) Query progress can be monitored at: [http://anuj-OptiPlex-9020:25000/query_plan?query_id=4b49d50ec0b973c1:ce474a1500000000|http://anuj-optiplex-9020:25000/query_plan?query_id=4b49d50ec0b973c1:ce474a1500000000] +---------------+------------+ |cp_master_id|data_status| +---------------+------------+ |11111111111|NEWREC| +---------------+------------+ Fetched 1 row(s) in 0.12s I think the bug is in the regex here - [https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127 ] It matches for "UPDATE" -[ [https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L124]|https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127] was: [localhost:21000] > CREATE TABLE test (cp_master_id STRING, data_status STRING) stored as parquet; Query: CREATE TABLE test (cp_master_id STRING, data_status STRING) stored as parquet Fetched 0 row(s) in 0.03s [localhost:21000] > insert into test (cp_master_id, data_status) values ('11111111111','NEWREC'); Query: insert into test (cp_master_id, data_status) values ('11111111111','NEWREC') Query submitted at: 2018-12-06 14:02:21 (Coordinator: http://anuj-OptiPlex-9020:25000) Query progress can be monitored at: http://anuj-OptiPlex-9020:25000/query_plan?query_id=14182abf0a7e4bb:8788cdab00000000 Modified 1 row(s) in 4.14s *********************************************************************************** [localhost:21000] > WITH tbl_incoming > AS > ( > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR > data_status='UPDATE') > ) > select * from test; Query: WITH tbl_incoming AS ( SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE') ) select * from test Modified 0 row(s) in 0.12s [localhost:21000] > [localhost:21000] > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE'); Query: SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR data_status='UPDATE') Query submitted at: 2018-12-06 14:05:48 (Coordinator: http://anuj-OptiPlex-9020:25000) Query progress can be monitored at: http://anuj-OptiPlex-9020:25000/query_plan?query_id=4b49d50ec0b973c1:ce474a1500000000 +--------------+-------------+ | cp_master_id | data_status | +--------------+-------------+ | 11111111111 | NEWREC | +--------------+-------------+ Fetched 1 row(s) in 0.12s I think the bug is in the regex here - [https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127 ] It matches for "UPDATE" -[ https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L124|https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127] > Impala shell not displaying results for a CTE query. > ---------------------------------------------------- > > Key: IMPALA-7939 > URL: https://issues.apache.org/jira/browse/IMPALA-7939 > Project: IMPALA > Issue Type: Bug > Affects Versions: Impala 3.1.0 > Reporter: Anuj Phadke > Priority: Major > > 1. > [localhost:21000] > CREATE TABLE test (cp_master_id STRING, data_status > STRING) stored as parquet; > Query: CREATE TABLE test (cp_master_id STRING, data_status STRING) stored as > parquet > Fetched 0 row(s) in 0.03s > 2. > [localhost:21000] > insert into test (cp_master_id, data_status) values > ('11111111111','NEWREC'); > Query: insert into test (cp_master_id, data_status) values > ('11111111111','NEWREC') > Query submitted at: 2018-12-06 14:02:21 (Coordinator: > [http://anuj-OptiPlex-9020:25000|http://anuj-optiplex-9020:25000/]) > Query progress can be monitored at: > [http://anuj-OptiPlex-9020:25000/query_plan?query_id=14182abf0a7e4bb:8788cdab00000000|http://anuj-optiplex-9020:25000/query_plan?query_id=14182abf0a7e4bb:8788cdab00000000] > Modified 1 row(s) in 4.14s > *********************************************************************************** > 3. > [localhost:21000] > WITH tbl_incoming > > AS > > ( > > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' > OR data_status='UPDATE') > > ) > > select * from test; > Query: WITH tbl_incoming > AS > ( > SELECT cp_master_id, data_status FROM test WHERE (data_status = 'NEWREC' OR > data_status='UPDATE') > ) > select * from test > Modified 0 row(s) in 0.12s > [localhost:21000] > > > 4. > [localhost:21000] > SELECT cp_master_id, data_status FROM test WHERE > (data_status = 'NEWREC' OR data_status='UPDATE'); > Query: SELECT cp_master_id, data_status FROM test WHERE (data_status = > 'NEWREC' OR data_status='UPDATE') > Query submitted at: 2018-12-06 14:05:48 (Coordinator: > [http://anuj-OptiPlex-9020:25000|http://anuj-optiplex-9020:25000/]) > Query progress can be monitored at: > [http://anuj-OptiPlex-9020:25000/query_plan?query_id=4b49d50ec0b973c1:ce474a1500000000|http://anuj-optiplex-9020:25000/query_plan?query_id=4b49d50ec0b973c1:ce474a1500000000] > +---------------+------------+ > |cp_master_id|data_status| > +---------------+------------+ > |11111111111|NEWREC| > +---------------+------------+ > Fetched 1 row(s) in 0.12s > > I think the bug is in the regex here - > > [https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127 > ] > It matches for "UPDATE" -[ > > [https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L124]|https://github.com/cloudera/Impala/blob/cdh5-trunk/shell/impala_shell.py#L1127] -- 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