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

2015-11-05 Thread Anne Yu (JIRA) 
Anne Yu created HIVE-12347:
--

 Summary: 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
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] [Created] (HIVE-12326) Support for "CRATE ROLE IF NOT EXISTS" and "DROP ROLE IF EXISTS"

2015-11-03 Thread Anne Yu (JIRA) 
Anne Yu created HIVE-12326:
--

 Summary: Support for "CRATE ROLE IF NOT EXISTS" and "DROP ROLE IF 
EXISTS"
 Key: HIVE-12326
 URL: https://issues.apache.org/jira/browse/HIVE-12326
 Project: Hive
  Issue Type: New Feature
Reporter: Anne Yu


For drop database/table/view, we support syntax such as,
{code}
DROP DATABASE/TABLE/VIEW [IF EXISTS]
{code}

Only for role, there is no support for IF EXISTS,
We might need to consider to add it.



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

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

2015-05-05 Thread Anne Yu (JIRA) 
Anne Yu created HIVE-10622:
--

 Summary: 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
 Fix For: 1.1.1


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)