[
https://issues.apache.org/jira/browse/IMPALA-7939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fredy Wijaya updated IMPALA-7939:
---------------------------------
Description:
{noformat}
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
{noformat}
I think the bug is in the regex here -
https://github.com/apache/impala/blob/master/shell/impala_shell.py#L1157
It matches for "UPDATE" -
https://github.com/apache/impala/blob/master/shell/impala_shell.py#L139
was:
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]
> 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
> Assignee: Fredy Wijaya
> Priority: Major
>
> {noformat}
> 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
> {noformat}
>
> I think the bug is in the regex here -
> https://github.com/apache/impala/blob/master/shell/impala_shell.py#L1157
> It matches for "UPDATE" -
> https://github.com/apache/impala/blob/master/shell/impala_shell.py#L139
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
