Anuj Phadke created IMPALA-7939:
-----------------------------------
Summary: 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
[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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
