Re: How to apply data mining on Hive?

If you are interested, you can also look at Apache hama which provides an MPI like interface on top of hadoop map-reduce. http://incubator.apache.org/hama/ On Jun 8, 2012 4:55 PM, "Mark Grover" wrote: > Hi Jason, > Hive does expose a JDBC interface which can by tools and applications. You > woul

Re: NaNs and Infinity support in HIVE?

To: user@hive.apache.org > Sent: Thursday, May 17, 2012 8:10:45 PM > Subject: Re: NaNs and Infinity support in HIVE? > > Can you paste a sample line of your data on HDFS and which column you are > trying to query? > > > Thanks > Nanda Vijaydev > > > On Mon, May 14,

is anybody looking at case-sensitivity for HIVE object names?

https://issues.apache.org/jira/browse/HIVE-912 talks about case-sensitivity, but it does not fixes the issue. I would like for HIVE to have to enforce case-sensitivity for HIVE object names. For eg. Oracle achieves this by enclosing the name in double quotes: "". This effort also take care of obje

Re: Order by Sort by partitioned columns

I think in HIVE the partitioned columns are virtual. They are not physical data columns but a directory name corr. to the partition key value to facilitate partition pruning during select. On May 14, 2012 6:29 AM, "Mark Grover" wrote: > Hi Shin, > If you could list the query that failed and the q

NaNs and Infinity support in HIVE?

Are NaNs and/or Infinity supported in HIVE? If yes, I wanted to know how are NaNs and Infinity values represented in HDFS files to be interpreted correctly in Hive. When I do 'select 1/0 from tab', I get a text value, "Infinity". However, when I enter "Infinity" v in my HDFS file represented by th

Re: removing hdfs table data directory does not throw error in hive

> without doing anything > > It is not an error case because hive job did not fail. > > > On Tue, Apr 24, 2012 at 6:25 AM, Sukhendu Chakraborty > wrote: >> >> I have a hive table tab3 with two columns (c1 int, c2 int) >> >> hive> load data local in

Re: WITH clause support in HIVE

Finance's Forex Awards 2009. > "The One to Watch" - Treasury Today's Adam Smith Awards 2009. > > > - Original Message - > From: "Sukhendu Chakraborty" > To: user@hive.apache.org > Sent: Tuesday, April 17, 2012 2:23:33 PM > Subject: Re: WIT

Re: WITH clause support in HIVE

Never mind. Its not implemented yet: https://issues.apache.org/jira/browse/HIVE-1180 On Tue, Apr 17, 2012 at 11:02 AM, Sukhendu Chakraborty wrote: > Resending, as I forgot to change the subject line in my last post. Pls > respond to this email. > > Does HIVE support SQL 99 'WI

WITH clause support in HIVE

Resending, as I forgot to change the subject line in my last post. Pls respond to this email. Does HIVE support SQL 99 'WITH' clause yet? I dod not find definitive answer in the web. I am in thr process of installing HIVE locally, but wanted to check with you before trying it. Thanks, -Sukhendu

Re: Creating Hbase table with pre-splitted regions using Hive QL

Does HIVE support SQL 99 'WITH' clause yet? I dod not find definitive answer in the web. I am in thr process of installing HIVE locally, but wanted to check with you before trying it. Thanks, -Sukhendu