hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zoltán Borók-Nagy (JIRA) <j...@apache.org>
Subject [jira] [Updated] (HIVE-21782) Cannot use query hints in views
Date Thu, 23 May 2019 11:48:00 GMT

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

Zoltán Borók-Nagy updated HIVE-21782:
-------------------------------------
    Description: 
Queries against views that contain query hints fail.

 
{noformat}
jdbc:hive2://localhost:11050/default> create view test as select /*+ MAPJOIN(time_dim)
*/ count(*)
from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);
jdbc:hive2://localhost:11050/default> explain select * from test;
Error: Error while compiling statement: FAILED: SemanticException line 1:32 missing EOF at
'(' near 'count' in definition of VIEW test [
select MAPJOIN(time_dim) count(*) from
`tpcds`.`store_sales` join `tpcds`.`time_dim` on (`store_sales`.`ss_sold_time_sk` = `time_dim`.`t_time_sk`)
] used as test at Line 1:22 (state=42000,code=40000)
{noformat}
Explain succeeds on same query but without using a view:
{noformat}
jdbc:hive2://localhost:11050/default> explain select /*+ MAPJOIN(time_dim) */ count(*)
from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);{noformat}
 
{noformat}
jdbc:hive2://localhost:11050/default> select version();
+----------------------------------------------------+
| _c0 |
+----------------------------------------------------+
| 3.1.0.6.0.99.0-147 recc35d355ca45862fcf4a10cb6968a2a1dfad73f |
+----------------------------------------------------+
{noformat}
The above worked with Hive 2.

 

  was:
Queries against views that contain query hints fail.

 
{noformat}
jdbc:hive2://localhost:11050/default> create view test as select /*+ MAPJOIN(time_dim)
*/ count(*)
from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);
jdbc:hive2://localhost:11050/default> explain select * from test;
Error: Error while compiling statement: FAILED: SemanticException line 1:32 missing EOF at
'(' near 'count' in definition of VIEW test [
select MAPJOIN(time_dim) count(*) from
`tpcds`.`store_sales` join `tpcds`.`time_dim` on (`store_sales`.`ss_sold_time_sk` = `time_dim`.`t_time_sk`)
] used as test at Line 1:22 (state=42000,code=40000)
{noformat}
 

Explain succeeds on same query but without using a view:
{noformat}
jdbc:hive2://localhost:11050/default> explain select /*+ MAPJOIN(time_dim) */ count(*)
from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);{noformat}
 

 
{noformat}
jdbc:hive2://localhost:11050/default> select version();
+----------------------------------------------------+
| _c0 |
+----------------------------------------------------+
| 3.1.0.6.0.99.0-147 recc35d355ca45862fcf4a10cb6968a2a1dfad73f |
+----------------------------------------------------+
{noformat}
The above worked with Hive 2.

 


> Cannot use query hints in views
> -------------------------------
>
>                 Key: HIVE-21782
>                 URL: https://issues.apache.org/jira/browse/HIVE-21782
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.0
>            Reporter: Zoltán Borók-Nagy
>            Priority: Major
>
> Queries against views that contain query hints fail.
>  
> {noformat}
> jdbc:hive2://localhost:11050/default> create view test as select /*+ MAPJOIN(time_dim)
*/ count(*)
> from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);
> jdbc:hive2://localhost:11050/default> explain select * from test;
> Error: Error while compiling statement: FAILED: SemanticException line 1:32 missing EOF
at '(' near 'count' in definition of VIEW test [
> select MAPJOIN(time_dim) count(*) from
> `tpcds`.`store_sales` join `tpcds`.`time_dim` on (`store_sales`.`ss_sold_time_sk` = `time_dim`.`t_time_sk`)
> ] used as test at Line 1:22 (state=42000,code=40000)
> {noformat}
> Explain succeeds on same query but without using a view:
> {noformat}
> jdbc:hive2://localhost:11050/default> explain select /*+ MAPJOIN(time_dim) */ count(*)
> from store_sales join time_dim on (ss_sold_time_sk = t_time_sk);{noformat}
>  
> {noformat}
> jdbc:hive2://localhost:11050/default> select version();
> +----------------------------------------------------+
> | _c0 |
> +----------------------------------------------------+
> | 3.1.0.6.0.99.0-147 recc35d355ca45862fcf4a10cb6968a2a1dfad73f |
> +----------------------------------------------------+
> {noformat}
> The above worked with Hive 2.
>  



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

Mime
View raw message