Re: [jira] Commented: (HIVE-474) Support for distinct selection on two or more columns

2010-02-25 Thread jian yi
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

2010-02-11 Thread jian yi
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

2010-02-11 Thread jian yi
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

2010-02-10 Thread jian yi
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?

2010-02-08 Thread jian yi
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?

2010-02-07 Thread jian yi
Hi all,

PL/SQL is very convenient, will hive support it?

Regards
Jian Yi