[jira] [Updated] (HIVE-3829) Hive CLI needs UNSET TBLPROPERTY command

[Namit Jain (JIRA)]

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

Namit Jain updated HIVE-3829:
-

   Resolution: Fixed
Fix Version/s: 0.11
 Hadoop Flags: Reviewed
   Status: Resolved  (was: Patch Available)

Committed. Thanks Zhenxiao

> Hive CLI needs UNSET TBLPROPERTY command
> 
>
> Key: HIVE-3829
> URL: https://issues.apache.org/jira/browse/HIVE-3829
> Project: Hive
>  Issue Type: Bug
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Fix For: 0.11
>
> Attachments: HIVE-3829.1.patch.txt, HIVE-3829.2.patch.txt, 
> HIVE-3829.3.patch.txt, HIVE-3829.4.patch.txt, HIVE-3829.5.patch.txt
>
>
> The Hive CLI currently supports
> ALTER TABLE  SET TBLPROPERTIES ('key1' = 'value1', 'key2' = 'value2', 
> ...);
> To add/change the value of table properties.
> It would be really useful if Hive also supported
> ALTER TABLE  UNSET TBLPROPERTIES ('key1', 'key2', ...);
> Which would remove table properties

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539227#comment-13539227
 ] 

Zhenxiao Luo commented on HIVE-3834:


Comments addressed. Review request at:
https://reviews.facebook.net/D7605

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Attachment: HIVE-3834.2.patch.txt

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Status: Patch Available  (was: Open)

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support hive: alter view ... as ..

[Namit Jain (JIRA)]

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

Namit Jain updated HIVE-3834:
-

Status: Open  (was: Patch Available)

comments

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3784) de-emphasize mapjoin hint

[Namit Jain (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539247#comment-13539247
 ] 

Namit Jain commented on HIVE-3784:
--

[~vinodkv], I agree that with change, it will be 2 map-only jobs instead of 1 
map job.
I haven't tested it myself, but seems likely.

But, the current code has way too much complexity to handle this special case. 
Ideally, this change
should be done as part of converting join tasks into conditional join tasks. 
That layer should be smarter
to see that there is no need of a conditional task, and a map-only task is 
possible. Also, another layer needs
to be written to merge consecutive map-only tasks.

Although, for this special case, we are taking a hit, I still believe this is 
the right long term way to go.

> de-emphasize mapjoin hint
> -
>
> Key: HIVE-3784
> URL: https://issues.apache.org/jira/browse/HIVE-3784
> Project: Hive
>  Issue Type: Improvement
>  Components: Query Processor
>Reporter: Namit Jain
>Assignee: Namit Jain
> Attachments: hive.3784.1.patch, hive.3784.2.patch, hive.3784.3.patch, 
> hive.3784.4.patch, hive.3784.5.patch
>
>
> hive.auto.convert.join has been around for a long time, and is pretty stable.
> When mapjoin hint was created, the above parameter did not exist.
> The only reason for the user to specify a mapjoin currently is if they want
> it to be converted to a bucketed-mapjoin or a sort-merge bucketed mapjoin.
> Eventually, that should also go away, but that may take some time to 
> stabilize.
> There are many rules in SemanticAnalyzer to handle the following trees:
> ReduceSink -> MapJoin
> Union  -> MapJoin
> MapJoin-> MapJoin
> This should not be supported anymore. In any of the above scenarios, the
> user can get the mapjoin behavior by setting hive.auto.convert.join to true
> and not specifying the hint. This will simplify the code a lot.
> What does everyone think ?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Summary: Support ALTER VIEW AS SELECT in Hive  (was: Support hive: alter 
view ... as ..)

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539269#comment-13539269
 ] 

Zhenxiao Luo commented on HIVE-3834:


Hi Namit, I updated my patch at:
https://reviews.facebook.net/D7605

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Status: Patch Available  (was: Open)

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support hive: alter view ... as ..

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Attachment: HIVE-3834.3.patch.txt

> Support hive: alter view ... as ..
> --
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3832) Insert overwrite doesn't create a dir if the skewed column position doesnt match

[Hudson (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539274#comment-13539274
 ] 

Hudson commented on HIVE-3832:
--

Integrated in Hive-trunk-h0.21 #1875 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1875/])
HIVE-3832 Insert overwrite doesn't create a dir if the skewed column 
position doesnt match
(Gang Tim Liu via namit) (Revision 1425589)

 Result = FAILURE
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1425589
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FileSinkOperator.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/ListBucketingCtx.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/SkewedColumnPositionPair.java
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_11.q
* /hive/trunk/ql/src/test/queries/clientpositive/list_bucket_dml_12.q
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_11.q.out
* /hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out


> Insert overwrite doesn't create a dir if the skewed column position doesnt 
> match
> 
>
> Key: HIVE-3832
> URL: https://issues.apache.org/jira/browse/HIVE-3832
> Project: Hive
>  Issue Type: Bug
>Reporter: Gang Tim Liu
>Assignee: Gang Tim Liu
> Fix For: 0.11
>
> Attachments: HIVE-3832.patch.1, HIVE-3832.patch.2
>
>
> If skewed column doesn't match the position in table column, insert overwrite 
> doesn't create sub-dir but put all into default directory.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Hive-trunk-h0.21 - Build # 1875 - Still Failing

[Apache Jenkins Server]

Changes for Build #1874

Changes for Build #1875
[namit] HIVE-3832 Insert overwrite doesn't create a dir if the skewed column 
position doesnt match
(Gang Tim Liu via namit)




1 tests failed.
FAILED:  
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_stats_aggregator_error_1

Error Message:
Forked Java VM exited abnormally. Please note the time in the report does not 
reflect the time until the VM exit.

Stack Trace:
junit.framework.AssertionFailedError: Forked Java VM exited abnormally. Please 
note the time in the report does not reflect the time until the VM exit.
at 
net.sf.antcontrib.logic.ForTask.doSequentialIteration(ForTask.java:259)
at net.sf.antcontrib.logic.ForTask.doToken(ForTask.java:268)
at net.sf.antcontrib.logic.ForTask.doTheTasks(ForTask.java:324)
at net.sf.antcontrib.logic.ForTask.execute(ForTask.java:244)




The Apache Jenkins build system has built Hive-trunk-h0.21 (build #1875)

Status: Still Failing

Check console output at https://builds.apache.org/job/Hive-trunk-h0.21/1875/ to 
view the results.

[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Namit Jain (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539282#comment-13539282
 ] 

Namit Jain commented on HIVE-3834:
--

+1

Running tests

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Build failed in Jenkins: Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #239

[Apache Jenkins Server]

See 


--
[...truncated 9916 lines...]

compile-test:
 [echo] Project: serde
[javac] Compiling 26 source files to 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/serde/test/classes
[javac] Note: Some input files use or override a deprecated API.
[javac] Note: Recompile with -Xlint:deprecation for details.
[javac] Note: Some input files use unchecked or unsafe operations.
[javac] Note: Recompile with -Xlint:unchecked for details.

create-dirs:
 [echo] Project: service
 [copy] Warning: 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/service/src/test/resources
 does not exist.

init:
 [echo] Project: service

ivy-init-settings:
 [echo] Project: service

ivy-resolve:
 [echo] Project: service
[ivy:resolve] :: loading settings :: file = 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/ivy/ivysettings.xml
[ivy:report] Processing 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/ivy/resolution-cache/org.apache.hive-hive-service-default.xml
 to 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/ivy/report/org.apache.hive-hive-service-default.html

ivy-retrieve:
 [echo] Project: service

compile:
 [echo] Project: service

ivy-resolve-test:
 [echo] Project: service

ivy-retrieve-test:
 [echo] Project: service

compile-test:
 [echo] Project: service
[javac] Compiling 2 source files to 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/service/test/classes

test:
 [echo] Project: hive

test-shims:
 [echo] Project: hive

test-conditions:
 [echo] Project: shims

gen-test:
 [echo] Project: shims

create-dirs:
 [echo] Project: shims
 [copy] Warning: 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/test/resources
 does not exist.

init:
 [echo] Project: shims

ivy-init-settings:
 [echo] Project: shims

ivy-resolve:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/ivy/ivysettings.xml
[ivy:report] Processing 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/ivy/resolution-cache/org.apache.hive-hive-shims-default.xml
 to 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/ivy/report/org.apache.hive-hive-shims-default.html

ivy-retrieve:
 [echo] Project: shims

compile:
 [echo] Project: shims
 [echo] Building shims 0.20

build_shims:
 [echo] Project: shims
 [echo] Compiling 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common/java;/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/0.20/java
 against hadoop 0.20.2 
(/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/hadoopcore/hadoop-0.20.2)

ivy-init-settings:
 [echo] Project: shims

ivy-resolve-hadoop-shim:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/ivy/ivysettings.xml

ivy-retrieve-hadoop-shim:
 [echo] Project: shims
 [echo] Building shims 0.20S

build_shims:
 [echo] Project: shims
 [echo] Compiling 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common/java;/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common-secure/java;/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/0.20S/java
 against hadoop 1.0.0 
(/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/hadoopcore/hadoop-1.0.0)

ivy-init-settings:
 [echo] Project: shims

ivy-resolve-hadoop-shim:
 [echo] Project: shims
[ivy:resolve] :: loading settings :: file = 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/ivy/ivysettings.xml

ivy-retrieve-hadoop-shim:
 [echo] Project: shims
 [echo] Building shims 0.23

build_shims:
 [echo] Project: shims
 [echo] Compiling 
/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common/java;/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/common-secure/java;/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/shims/src/0.23/java
 against hadoop 0.23.3 
(/x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/hadoopcore/hadoop-0.23.3)

ivy-init-settings:
 [echo] Project: shim

Jenkins build is back to normal : Hive-0.9.1-SNAPSHOT-h0.21 #239

[Apache Jenkins Server]

See 

[jira] [Commented] (HIVE-3829) Hive CLI needs UNSET TBLPROPERTY command

[Hudson (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539332#comment-13539332
 ] 

Hudson commented on HIVE-3829:
--

Integrated in Hive-trunk-h0.21 #1876 (See 
[https://builds.apache.org/job/Hive-trunk-h0.21/1876/])
HIVE-3829 Hive CLI needs UNSET TBLPROPERTY command
(Zhenxiao Luo via namit) (Revision 1425604)

 Result = SUCCESS
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1425604
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/ErrorMsg.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
* 
/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzerFactory.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/AlterTableDesc.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/plan/HiveOperation.java
* /hive/trunk/ql/src/test/queries/clientnegative/set_table_property.q
* /hive/trunk/ql/src/test/queries/clientnegative/unset_table_property.q
* /hive/trunk/ql/src/test/queries/clientnegative/unset_view_property.q
* /hive/trunk/ql/src/test/queries/clientpositive/unset_table_view_property.q
* /hive/trunk/ql/src/test/results/clientnegative/set_table_property.q.out
* /hive/trunk/ql/src/test/results/clientnegative/unset_table_property.q.out
* /hive/trunk/ql/src/test/results/clientnegative/unset_view_property.q.out
* /hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out


> Hive CLI needs UNSET TBLPROPERTY command
> 
>
> Key: HIVE-3829
> URL: https://issues.apache.org/jira/browse/HIVE-3829
> Project: Hive
>  Issue Type: Bug
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Fix For: 0.11
>
> Attachments: HIVE-3829.1.patch.txt, HIVE-3829.2.patch.txt, 
> HIVE-3829.3.patch.txt, HIVE-3829.4.patch.txt, HIVE-3829.5.patch.txt
>
>
> The Hive CLI currently supports
> ALTER TABLE  SET TBLPROPERTIES ('key1' = 'value1', 'key2' = 'value2', 
> ...);
> To add/change the value of table properties.
> It would be really useful if Hive also supported
> ALTER TABLE  UNSET TBLPROPERTIES ('key1', 'key2', ...);
> Which would remove table properties

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Hive-trunk-h0.21 - Build # 1876 - Fixed

[Apache Jenkins Server]

Changes for Build #1874

Changes for Build #1875
[namit] HIVE-3832 Insert overwrite doesn't create a dir if the skewed column 
position doesnt match
(Gang Tim Liu via namit)


Changes for Build #1876
[namit] HIVE-3829 Hive CLI needs UNSET TBLPROPERTY command
(Zhenxiao Luo via namit)




All tests passed

The Apache Jenkins build system has built Hive-trunk-h0.21 (build #1876)

Status: Fixed

Check console output at https://builds.apache.org/job/Hive-trunk-h0.21/1876/ to 
view the results.

[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Namit Jain (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539357#comment-13539357
 ] 

Namit Jain commented on HIVE-3834:
--

Can you add documentation once it is committed ?

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Namit Jain (JIRA)]

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

Namit Jain updated HIVE-3834:
-

Status: Open  (was: Patch Available)

The following tests failed:

create_view.q
create_or_replace_view.q

Can you take a look ?

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Attachment: HIVE-3834.4.patch.txt

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Zhenxiao Luo (JIRA)]

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

Zhenxiao Luo updated HIVE-3834:
---

Status: Patch Available  (was: Open)

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (HIVE-3834) Support ALTER VIEW AS SELECT in Hive

[Zhenxiao Luo (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-3834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13539371#comment-13539371
 ] 

Zhenxiao Luo commented on HIVE-3834:


Hi Namit, Sorry for the failure. I fixed the failure at:
https://reviews.facebook.net/D7605

Sure. I will add documentation about ALTER VIEW AS SELECT when this task is 
committed.

Thanks,
Zhenxiao

> Support ALTER VIEW AS SELECT in Hive
> 
>
> Key: HIVE-3834
> URL: https://issues.apache.org/jira/browse/HIVE-3834
> Project: Hive
>  Issue Type: New Feature
>Reporter: Zhenxiao Luo
>Assignee: Zhenxiao Luo
> Attachments: HIVE-3834.1.patch.txt, HIVE-3834.2.patch.txt, 
> HIVE-3834.3.patch.txt, HIVE-3834.4.patch.txt
>
>
> Hive supports "alter view" on setting property, add/drop partition etc but 
> not "as".
> If you want to change "as" part, you have to drop view, recreate it and 
> backfill partition etc. pretty painful.
> It will be nice to support this. The reference is mysql syntax 
> http://dev.mysql.com/doc/refman/5.0/en/alter-view.html

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira