Re: [jira] Commented: (HIVE-474) Support for distinct selection on two or more columns
Hi Liu, How to implement to support for distinct selection on two or more columns? Regards Jian 2010/2/26 Liu (JIRA) j...@apache.org [ https://issues.apache.org/jira/browse/HIVE-474?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12838683#action_12838683] Liu commented on HIVE-474: -- We have implemented this feature using union type, as metioned as A2 by Zheng. Support for distinct selection on two or more columns - Key: HIVE-474 URL: https://issues.apache.org/jira/browse/HIVE-474 Project: Hadoop Hive Issue Type: Improvement Components: Query Processor Reporter: Alexis Rondeau The ability to select distinct several, individual columns as by example: select count(distinct user), count(distinct session) from actions; Currently returns the following failure: FAILED: Error in semantic analysis: line 2:7 DISTINCT on Different Columns not Supported user -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. -- Hadoop Forum: http://bbs.hadoopor.com
Build hive failed, SVN update on today
Buildfile: D:\hadoop\src\hive\build.xml jar: create-dirs: compile-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks deploy-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks jar: init: compile: ivy-init-dirs: ivy-download: [get] Getting: http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar [get] To: D:\hadoop\src\hive\build\ivy\lib\ivy-2.1.0.jar [get] Not modified - so not downloaded ivy-probe-antlib: ivy-init-antlib: ivy-init: ivy-retrieve-hadoop-source: [ivy:retrieve] :: Ivy 2.0.0-rc2 - 20081028224207 :: http://ant.apache.org/ivy/ :: :: loading settings :: file = D:\hadoop\src\hive\ivy\ivysettings.xml BUILD FAILED D:\hadoop\src\hive\build.xml:148: The following error occurred while executing this line: D:\hadoop\src\hive\build.xml:93: The following error occurred while executing this line: D:\hadoop\src\hive\shims\build.xml:55: The following error occurred while executing this line: D:\hadoop\src\hive\build-common.xml:180: impossible to configure ivy:settings with given file: D:\hadoop\src\hive\ivy\ivysettings.xml : java.text.ParseException: failed to load settings from file:/D:/hadoop/src/hive/ivy/ivysettings.xml: impossible to set defaultTTL to eternal on class org.apache.ivy.core.cache.DefaultRepositoryCacheManager Total time: 2 seconds
Re: Build hive failed, SVN update on today
Hi carl, Thank your help, but I can't access the url: The webpage at * http://www.mail-archive.com/hive-u...@hadoop.apache.org/msg02361.html* might be temporarily down or it may have moved permanently to a new web address. 2010/2/11 Carl Steinbach c...@cloudera.com Hi Jian, The answer to your problem is here: http://www.mail-archive.com/hive-u...@hadoop.apache.org/msg02361.html On Thu, Feb 11, 2010 at 4:32 AM, jian yi eyj...@gmail.com wrote: Buildfile: D:\hadoop\src\hive\build.xml jar: create-dirs: compile-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks deploy-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks jar: init: compile: ivy-init-dirs: ivy-download: [get] Getting: http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar [get] To: D:\hadoop\src\hive\build\ivy\lib\ivy-2.1.0.jar [get] Not modified - so not downloaded ivy-probe-antlib: ivy-init-antlib: ivy-init: ivy-retrieve-hadoop-source: [ivy:retrieve] :: Ivy 2.0.0-rc2 - 20081028224207 :: http://ant.apache.org/ivy/ :: :: loading settings :: file = D:\hadoop\src\hive\ivy\ivysettings.xml BUILD FAILED D:\hadoop\src\hive\build.xml:148: The following error occurred while executing this line: D:\hadoop\src\hive\build.xml:93: The following error occurred while executing this line: D:\hadoop\src\hive\shims\build.xml:55: The following error occurred while executing this line: D:\hadoop\src\hive\build-common.xml:180: impossible to configure ivy:settings with given file: D:\hadoop\src\hive\ivy\ivysettings.xml : java.text.ParseException: failed to load settings from file:/D:/hadoop/src/hive/ivy/ivysettings.xml: impossible to set defaultTTL to eternal on class org.apache.ivy.core.cache.DefaultRepositoryCacheManager Total time: 2 seconds -- Hadoop Forum: http://bbs.hadoopor.com
Build latest hive failed
Hi all, Updated today. See below: Buildfile: D:\hadoop\src\hive\build.xml jar: create-dirs: compile-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks [javac] Compiling 1 source file to D:\hadoop\src\hive\build\anttasks\classes [javac] 注意:D:\hadoop\src\hive\ant\src\org\apache\hadoop\hive\ant\QTestGenTask.java 使用或覆盖了已过时的 API。 [javac] 注意:要了解详细信息,请使用 -Xlint:deprecation 重新编译。 deploy-ant-tasks: create-dirs: init: compile: [echo] Compiling: anttasks jar: [jar] Building jar: D:\hadoop\src\hive\build\anttasks\hive-anttasks-0.6.0.jar init: compile: ivy-init-dirs: [mkdir] Created dir: D:\hadoop\src\hive\build\ivy [mkdir] Created dir: D:\hadoop\src\hive\build\ivy\lib [mkdir] Created dir: D:\hadoop\src\hive\build\ivy\report [mkdir] Created dir: D:\hadoop\src\hive\build\ivy\maven ivy-download: [get] Getting: http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar [get] To: D:\hadoop\src\hive\build\ivy\lib\ivy-2.1.0.jar ivy-probe-antlib: ivy-init-antlib: ivy-init: ivy-retrieve-hadoop-source: [ivy:retrieve] :: Ivy 2.0.0-rc2 - 20081028224207 :: http://ant.apache.org/ivy/ :: :: loading settings :: file = D:\hadoop\src\hive\ivy\ivysettings.xml BUILD FAILED D:\hadoop\src\hive\build.xml:148: The following error occurred while executing this line: D:\hadoop\src\hive\build.xml:93: The following error occurred while executing this line: D:\hadoop\src\hive\shims\build.xml:55: The following error occurred while executing this line: D:\hadoop\src\hive\build-common.xml:180: impossible to configure ivy:settings with given file: D:\hadoop\src\hive\ivy\ivysettings.xml : java.text.ParseException: failed to load settings from file:/D:/hadoop/src/hive/ivy/ivysettings.xml: impossible to set defaultTTL to eternal on class org.apache.ivy.core.cache.DefaultRepositoryCacheManager Total time: 12 seconds
Re: Will hive support PL/SQL?
Many people want to migrate oracle PL/SQL to Hive, it's difficult that if PL is not supported. 2010/2/8 Jeff Zhang zjf...@gmail.com I think PL/SQL is one kind of DSL upon SQL, so it is possible to build similar things upon HSQL. Ruby DSL may be one option On Mon, Feb 8, 2010 at 4:20 PM, Mafish Liu maf...@gmail.com wrote: Hive supports SQL-like language named HSQL. Refer http://wiki.apache.org/hadoop/Hive/LanguageManual for more details. 2010/2/8 jian yi eyj...@gmail.com: Hi all, PL/SQL is very convenient, will hive support it? Regards Jian Yi -- maf...@gmail.com -- Best Regards Jeff Zhang
Will hive support PL/SQL?
Hi all, PL/SQL is very convenient, will hive support it? Regards Jian Yi