[jira] [Updated] (HIVE-12347) Different tables' external partitions can point to the same location without any warning or error

[Anne Yu (JIRA)]

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

Anne Yu updated HIVE-12347:
---
Affects Version/s: 1.2.1
  Component/s: Hive

> Different tables' external partitions can point to the same location without 
> any warning or error
> -
>
> Key: HIVE-12347
> URL: https://issues.apache.org/jira/browse/HIVE-12347
> Project: Hive
>  Issue Type: Bug
>  Components: Hive
>Affects Versions: 1.2.1
>Reporter: Anne Yu
>
> {code}
> CREATE TABLE testloc1 (test STRING) PARTITIONED BY(day INT, hour INT, min 
> INT);
> CREATE TABLE testloc2 (test STRING) PARTITIONED BY(day INT, hour INT, min 
> INT);
> ALTER TABLE testloc1 add partition (day="01", hour="01", min="01") location 
> '/hive/pipeline/data/01/01/01’;
> ALTER TABLE testloc2 add partition (day="01", hour="01", min="01") location 
> '/hive/pipeline/data/01/01/01’;
> {code}
> The issue is if overwrite data into testloc1 then testloc2, testloc1 data 
> will be wiped out. For example,
> {code}
> insert overwrite table testloc1 partition (day="01", hour="01", min="01") 
> select "test1" from test_tb;
> insert overwrite table testloc2 partition (day="01", hour="01", min="01") 
> select "test2" from test_tb;
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Resolved] (HIVE-10622) Hive doc error: 'from' is a keyword, when use it as a column name throw error.

[Anne Yu (JIRA)]

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

Anne Yu resolved HIVE-10622.

Resolution: Fixed

> Hive doc error: 'from' is a keyword, when use it as a column name throw error.
> --
>
> Key: HIVE-10622
> URL: https://issues.apache.org/jira/browse/HIVE-10622
> Project: Hive
>  Issue Type: Bug
>  Components: Documentation
>Affects Versions: 1.1.1
>Reporter: Anne Yu
>
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML, Use 
> "from" as a column name in create table, throw error.
> {code}
> CREATE TABLE pageviews (userid VARCHAR(64), link STRING, from STRING)
>   PARTITIONED BY (datestamp STRING) CLUSTERED BY (userid) INTO 256 BUCKETS 
> STORED AS ORC;
> Error: Error while compiling statement: FAILED: ParseException line 1:57 
> cannot recognize input near 'from' 'STRING' ')' in column specification 
> (state=42000,code=4)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)