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)
