[GitHub] hive pull request #422: HIVE-20463: fix parse `from_join_clause` error

2018-08-25 Thread lleohao 
GitHub user lleohao opened a pull request:

https://github.com/apache/hive/pull/422

HIVE-20463: fix parse `from_join_clause` error

Fix https://issues.apache.org/jira/browse/HIVE-20463

Signed-off-by: Hao Zhou lleo...@hotmail.com

You can merge this pull request into a Git repository by running:

$ git pull https://github.com/lleohao/hive master

Alternatively you can review and apply these changes as the patch at:

https://github.com/apache/hive/pull/422.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

This closes #422


commit a1634bac6b65b8be5d2d4090222ec2a8aae87bf6
Author: lleohao 
Date:   2018-08-25T16:04:31Z

HIVE-20463: fix parse `from_join_clause` error




---

[jira] [Created] (HIVE-20463) Hplsql.g4 - 'from_clause' parses the keyword `JOIN` into 'from_alias_clause' in 'from_table_clause' when parsing 'from_join_clause'

2018-08-25 Thread Hao Zhou (JIRA) 
Hao Zhou created HIVE-20463:
---

 Summary: Hplsql.g4 - 'from_clause' parses the keyword `JOIN` into 
'from_alias_clause' in 'from_table_clause' when parsing 'from_join_clause'
 Key: HIVE-20463
 URL: https://issues.apache.org/jira/browse/HIVE-20463
 Project: Hive
  Issue Type: Bug
  Components: CLI
Affects Versions: 3.1.0
Reporter: Hao Zhou
Assignee: Hao Zhou
 Fix For: 3.1.0


'from_clause' parses the keyword `JOIN` into 'from_alias_clause' in 
'from_table_clause' when parsing 'from_join_clause'.

 

example:

Parse sql {{SELECT `k1, v1, k2, v2 FROM a JOIN b ON k1 = k2;`.}}

Now grammar will parse `{{JOIN`}} as a `{{from_alias_clause`}}, but it should be
a `{{from_join_clause`}};

 

 



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

[jira] [Created] (HIVE-20462) "CREATE VIEW IF NOT EXISTS" fails view already exists

2018-08-25 Thread static-max (JIRA) 
static-max created HIVE-20462:
-

 Summary: "CREATE VIEW IF NOT EXISTS" fails view already exists
 Key: HIVE-20462
 URL: https://issues.apache.org/jira/browse/HIVE-20462
 Project: Hive
  Issue Type: Bug
  Components: Hive
Affects Versions: 3.1.0
 Environment: HDP 3.0

Hive 3.1.0.3.0.0.0-1634
Reporter: static-max


After upgrading to Hive 3.1 from Hive 1.2, I can't run my queries anymore. It 
seems that "if not exists" is ignored in "create view".

*Example:*
 # create view if not exists test as select 1;
 # create view if not exists test as select 1;

The second call fails with "Table already exists: default.test". I changed this 
to "create or replace view" as a workaround.

Also documented [link 
here|https://community.hortonworks.com/questions/214772/hdp-3-hive-create-view-if-not-exists-fails.html|]



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