[jira] [Created] (HIVE-21782) Cannot use query hints in views

["Zoltán Borók-Nagy (JIRA)" <ji...@apache.org>]

Zoltán Borók-Nagy created HIVE-21782:
----------------------------------------

             Summary: 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


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)