[jira] [Commented] (HIVE-2933) analyze command throw NPE when table doesn't exists

2012-04-20 Thread ransom.hezhiqiang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13258450#comment-13258450
 ] 

ransom.hezhiqiang commented on HIVE-2933:
-

please review it.

 analyze command throw NPE when table doesn't exists
 ---

 Key: HIVE-2933
 URL: https://issues.apache.org/jira/browse/HIVE-2933
 Project: Hive
  Issue Type: Bug
  Components: Statistics
Affects Versions: 0.8.1
Reporter: alex gemini
Priority: Minor
 Attachments: HIVE-2933-0.8.1-2.patch


 analyze command throw NPE when table doesn't exists

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2886) distinct with order by fails with Java SQL exception.

2012-04-09 Thread ransom.hezhiqiang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2886?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13249786#comment-13249786
 ] 

ransom.hezhiqiang commented on HIVE-2886:
-

distinct can only effect on  one table

 distinct with order by fails with Java SQL exception.
 -

 Key: HIVE-2886
 URL: https://issues.apache.org/jira/browse/HIVE-2886
 Project: Hive
  Issue Type: Bug
  Components: SQL
Affects Versions: 0.7.1
Reporter: Mauro Cazzari

 The following select:
 select distinct TXT_1.`a`, TXT_1.`b` from `MYTAB` TXT_1 order by TXT_1.`a` asc
 fails with a Java SQL exception. Note that if the distinct or the table 
 alias is removed from the SQL, the statement executes fine.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira




[jira] [Commented] (HIVE-2591) Hive 0.7.1 fails with Exception in thread main java.lang.NoSuchFieldError: type

2012-03-17 Thread ransom.hezhiqiang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13232031#comment-13232031
 ] 

ransom.hezhiqiang commented on HIVE-2591:
-

type error:
it looks some problems in antlr. is the hive.g files changed?

 Hive 0.7.1 fails with Exception in thread main java.lang.NoSuchFieldError: 
 type
 ---

 Key: HIVE-2591
 URL: https://issues.apache.org/jira/browse/HIVE-2591
 Project: Hive
  Issue Type: Bug
  Components: CLI, JDBC, SQL
Affects Versions: 0.7.1
 Environment: Intel Core2 Quad CPU Q8400 @2.66GHz
 4 GB RAM
 Ubuntu 10.10 32 bit
 JDK 6.0_27
 Apache Ant 1.8.0
 Apache Hive 0.7.1
 Apache Hadoop 0.20.203.0
Reporter: Prashanth
Priority: Blocker
  Labels: hive

 Hi,
 When I try to invoke hive and type in SHOW TABLES in cli in the environment 
 as explained above, I get Exception in thread main 
 java.lang.NoSuchFieldError: type and I am not able to use it at all.
 Is there any temporary fix for this? Please let me know, if I am making any 
 mistake here.
 I have downloaded Hive 0.7.1 from the download link as mentioned in the Hive 
 Wiki. The download url is http://hive.apache.org/releases.html.
 /opt/hive-0.7.1$ hive
 WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use 
 org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
 Hive history file=/tmp/hadoop/hive_job_log_hduser_20190121_764439225.txt
 hive SHOW TABLES;
 Exception in thread main java.lang.NoSuchFieldError: type
 at 
 org.apache.hadoop.hive.ql.parse.HiveLexer.mKW_SHOW(HiveLexer.java:1234)
 at 
 org.apache.hadoop.hive.ql.parse.HiveLexer.mTokens(HiveLexer.java:5942)
 at org.antlr.runtime.Lexer.nextToken(Lexer.java:89)
 at 
 org.antlr.runtime.BufferedTokenStream.fetch(BufferedTokenStream.java:133)
 at 
 org.antlr.runtime.BufferedTokenStream.sync(BufferedTokenStream.java:127)
 at 
 org.antlr.runtime.CommonTokenStream.setup(CommonTokenStream.java:127)
 at org.antlr.runtime.CommonTokenStream.LT(CommonTokenStream.java:91)
 at 
 org.apache.hadoop.hive.ql.parse.HiveParser.statement(HiveParser.java:521)
 at 
 org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:436)
 at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:327)
 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
 at 
 org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at 
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at 
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
 I am not sure what is the actual issue here or rather how to fix it.
 Can you please let me know if there is any workaround for this.
 Alternatively I tried building hive from the SVN source repo.
 I am neither able to build hive from SVN. I get the following error.
 [datanucleusenhancer]   D:\hive\build\ivy\lib\default\zookeeper-3.3.1.jar
 [datanucleusenhancer] Exception in thread main java.lang.VerifyError: 
 Expecting a stackmap frame at branch target 76 in method 
 org.apache.hadoop.hive.metastore.model.MDatabase.jdoCopyField(Lorg/apache/hadoop/hive/metastore/model/MDatabase;I)V
  at offset 1
 [datanucleusenhancer]   at java.lang.Class.getDeclaredFields0(Native Method)
 [datanucleusenhancer]   at 
 java.lang.Class.privateGetDeclaredFields(Class.java:2308)
 [datanucleusenhancer]   at java.lang.Class.getDeclaredFields(Class.java:1760)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.ClassMetaData.addMetaDataForMembersNotInMetaData(ClassMetaData.java:358)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.ClassMetaData.populate(ClassMetaData.java:199)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.MetaDataManager$1.run(MetaDataManager.java:2394)
 [datanucleusenhancer]   at java.security.AccessController.doPrivileged(Native 
 Method)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.MetaDataManager.populateAbstractClassMetaData(MetaDataManager.java:2388)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.MetaDataManager.populateFileMetaData(MetaDataManager.java:2225)
 [datanucleusenhancer]   at 
 org.datanucleus.metadata.MetaDataManager.initialiseFileMetaDataForUse(MetaDataManager.java:925)
 [datanucleusenhancer]   at 
 

[jira] [Commented] (HIVE-2842) Table with column that shares name fails upon query

2012-03-07 Thread ransom.hezhiqiang (Commented) (JIRA)

[ 
https://issues.apache.org/jira/browse/HIVE-2842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13224226#comment-13224226
 ] 

ransom.hezhiqiang commented on HIVE-2842:
-

SELECT a.t FROM t a;
add alias to table will be success.
table t alias is also t,so we must rename it or disable it when validate.

 Table with column that shares name fails upon query
 ---

 Key: HIVE-2842
 URL: https://issues.apache.org/jira/browse/HIVE-2842
 Project: Hive
  Issue Type: Bug
Reporter: Kevin Wilfong

 CREATE TABLE t (t STRING);
 SELECT t FROM t;
 This will result in 
 FAILED: Error in semantic analysis: Line 1:7 Ambiguous table alias or column 
 reference 't'
 Similarly
 SELECT t2 FROM t t2;
 will result in the same exception
 SELECT t from t t2;
 will succeed.
 MySQL apparently supports this, so Hive should as well.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira