[jira] [Updated] (HIVE-2777) ability to add and drop partitions atomically

2013-09-02 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi updated HIVE-2777: - Status: Open (was: Patch Available) Canceling old patch, I will submit a rebased one

Re: Query builder for Hive

2013-06-27 Thread Aniket Mokashi
Try- https://code.google.com/a/apache-extras.org/p/hipy/ On Thu, Jun 27, 2013 at 3:42 PM, Claudia Isabel Núñez < claudia.nunez.robin...@gmail.com> wrote: > Hi, do you know of any java library that allows me to construct dynamic > hive queries? Something like: > > String query = table.select(col

Re: Does Hive 0.11 have Query Flattening optimizations?

2013-06-27 Thread Aniket Mokashi
Hi Mihir, I am almost certain that both the queries will compile to the same MR plan in hive (I haven't checked though). In fact, having clause is a syntactic sugar to achieve whats done in the nested query. Take a look at: https://issues.apache.org/jira/browse/HIVE-1790 Thanks, Aniket On Wed,

Re: API to map Hive Table extended description into Java Objects

2013-06-27 Thread Aniket Mokashi
Following should help:- http://hive.apache.org/docs/r0.10.0/api/org/apache/hadoop/hive/metastore/api/Table.html http://hive.apache.org/docs/r0.10.0/api/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.html ~Aniket On Thu, Jun 27, 2013 at 7:21 AM, Gelesh G Omathil wrote: > Hi, > > I would

[jira] [Commented] (HIVE-2361) Add some UDFs which help to migrate Oracle to Hive

2013-02-13 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13578209#comment-13578209 ] Aniket Mokashi commented on HIVE-2361: -- Please post this discussion to hive-

[jira] [Updated] (HIVE-2095) auto convert map join bug

2012-11-12 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi updated HIVE-2095: - Description: 1) when considering to choose one table as the big table candidate for a map join

[jira] [Commented] (HIVE-3299) UDF DAYNAME(date) to HIVE

2012-09-18 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13458248#comment-13458248 ] Aniket Mokashi commented on HIVE-3299: -- @Carl, are we not considering adding new

[jira] [Assigned] (HIVE-3044) INDEX UDF is not working

2012-08-22 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi reassigned HIVE-3044: Assignee: Aniket Mokashi (was: Chinna Rao Lalam) > INDEX UDF is not work

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-07-21 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13420102#comment-13420102 ] Aniket Mokashi commented on HIVE-2777: -- Thanks Namit. We are using S3 as our sto

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-07-20 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13419639#comment-13419639 ] Aniket Mokashi commented on HIVE-2777: -- Can someone take a look at

[jira] [Commented] (HIVE-3044) INDEX UDF is not working

2012-06-25 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3044?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13400950#comment-13400950 ] Aniket Mokashi commented on HIVE-3044: -- This is probably broken because index

Re: Developing Hive UDF in eclipse

2012-06-05 Thread Aniket Mokashi
Put hive-exec*.jar in your eclipse classpath. (project properties-> java build path -> libraries) On Tue, Jun 5, 2012 at 8:52 AM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > Did you try this[1]? It had got me most of my way through the process. > > [1] https://cwiki.apache.o

Re: non-string partition columns

2012-05-29 Thread Aniket Mokashi
We are using non-string partition columns in production as well. Thanks, Aniket On Sat, May 26, 2012 at 1:20 AM, Philip Tromans wrote: > We're using non-string partition columns in production. I think non string > partition columns are a good thing to have - it allows you to do all sorts > of da

Re: Error while executing program with Hive JDBC

2012-04-26 Thread Aniket Mokashi
put libthrift and libfb303 jars on classpath. Thanks, Aniket On Wed, Apr 25, 2012 at 11:14 PM, Bhavesh Shah wrote: > Hello all, > I have written this small program But I am getting error. > > Program: > - > import java.io.FileWriter; > import java.io.InputStream; > import java.sql.Co

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-04-25 Thread Aniket Mokashi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262282#comment-13262282 ] Aniket Mokashi commented on HIVE-2777: -- Hi Ashutosh, Let me know if the patc

[jira] [Commented] (HIVE-2006) Make the HiveServer/Client socket timeout configurable

2012-04-16 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13254936#comment-13254936 ] Aniket Mokashi commented on HIVE-2006: -- For hive client, we

[jira] [Commented] (HIVE-2702) listPartitionsByFilter only supports non-string partitions

2012-03-18 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13232319#comment-13232319 ] Aniket Mokashi commented on HIVE-2702: -- I agree on your comment, I didn't

[jira] [Updated] (HIVE-2777) ability to add and drop partitions atomically

2012-03-12 Thread Aniket Mokashi (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi updated HIVE-2777: - Status: Patch Available (was: Open) > ability to add and drop partitions atomica

Building with thrift

2012-03-06 Thread Aniket Mokashi
Hi, I am trying to build hive source code with thrift. I get following error- lgmac-amokashi:metastore amokashi$ ant thriftif -Dthrift.home=/usr/local/ Buildfile: /work/projects/hive-trunk/metastore/build.xml check-thrift-home: [echo] Project: metastore thriftif: [echo] Project: metas

[jira] [Commented] (HIVE-2836) CREATE TABLE LIKE does not copy table type

2012-03-04 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2836?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13222143#comment-13222143 ] Aniket Mokashi commented on HIVE-2836: -- Read Zheng Shao's comment on HIVE-5

[jira] [Updated] (HIVE-2702) listPartitionsByFilter only supports non-string partitions

2012-03-02 Thread Aniket Mokashi (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi updated HIVE-2702: - Status: Patch Available (was: Open) > listPartitionsByFilter only supports non-str

[jira] [Updated] (HIVE-2702) listPartitionsByFilter only supports non-string partitions

2012-03-02 Thread Aniket Mokashi (Updated) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi updated HIVE-2702: - Attachment: HIVE-2702.1.patch > listPartitionsByFilter only supports non-string partiti

Re: Thrift build

2012-02-08 Thread Aniket Mokashi
h it. Am I missing anything? Thanks, Aniket On Wed, Feb 8, 2012 at 3:58 PM, Namit Jain wrote: > Check out svn+ssh://tubbs/svnhive/hadoop/external/thrift-0.7.0 > > And set your thrift.home to the above > > > On 2/8/12 12:32 PM, "Aniket Mokashi" wrote:

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-02-08 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13203913#comment-13203913 ] Aniket Mokashi commented on HIVE-2777: -- I am adding deleteData option there, dele

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-02-06 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13201963#comment-13201963 ] Aniket Mokashi commented on HIVE-2777: -- Yes, our goal is to merge multiple s

[jira] [Commented] (HIVE-2777) ability to add and drop partitions atomically

2012-02-04 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13200674#comment-13200674 ] Aniket Mokashi commented on HIVE-2777: -- Yes. Basically, I would like to support m

[jira] [Created] (HIVE-2777) ability to add and drop partitions atomically

2012-02-04 Thread Aniket Mokashi (Created) (JIRA)
Reporter: Aniket Mokashi Fix For: 0.9.0 Hive should have ability to atomically add and drop partitions. This way admins can change partitions atomically without breaking the running jobs. It allows admin to merge several partitions into one. Essentially, we would like to have an

[jira] [Commented] (HIVE-2609) NPE when pruning partitions by thrift method get_partitions_by_filter

2012-01-25 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13193593#comment-13193593 ] Aniket Mokashi commented on HIVE-2609: -- Hmm, unfortunately it didnt work for me,

[jira] [Commented] (HIVE-2609) NPE when pruning partitions by thrift method get_partitions_by_filter

2012-01-24 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13192694#comment-13192694 ] Aniket Mokashi commented on HIVE-2609: -- @Mithun, How did you change these jars?

[jira] [Resolved] (HIVE-2701) listPartitionsByFilter only supports non-string partitions

2012-01-09 Thread Aniket Mokashi (Resolved) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2701?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aniket Mokashi resolved HIVE-2701. -- Resolution: Duplicate > listPartitionsByFilter only supports non-string partiti

[jira] [Commented] (HIVE-2701) listPartitionsByFilter only supports non-string partitions

2012-01-09 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13183127#comment-13183127 ] Aniket Mokashi commented on HIVE-2701: -- Possibly a browser bug! I will close

[jira] [Created] (HIVE-2702) listPartitionsByFilter only supports non-string partitions

2012-01-09 Thread Aniket Mokashi (Created) (JIRA)
: 0.8.1 Reporter: Aniket Mokashi listPartitionsByFilter supports only non-string partitions. This is because its explicitly specified in generateJDOFilterOverPartitions in ExpressionTree.java. //Can only support partitions whose types are string if( ! table.getPartitionKeys().get

[jira] [Created] (HIVE-2701) listPartitionsByFilter only supports non-string partitions

2012-01-09 Thread Aniket Mokashi (Created) (JIRA)
: 0.8.1 Reporter: Aniket Mokashi listPartitionsByFilter supports only non-string partitions. This is because its explicitly specified in generateJDOFilterOverPartitions in ExpressionTree.java. //Can only support partitions whose types are string if( ! table.getPartitionKeys().get

Re: How to calculate count of quarter wise record in Hive?

2012-01-09 Thread Aniket Mokashi
select quarter, COUNT(*) from table group by quarter? On Mon, Jan 9, 2012 at 10:06 PM, Bhavesh Shah wrote: > Hello, > I want to calculate count of quarter wise record in Hive. > (e.g.: In 1st Quarter - 72 (counts) likewise for other quarter) > > How can we calculate it through query or UDF in Hiv

Re: Error in running hive query

2012-01-06 Thread Aniket Mokashi
[moving to user@hive] Can you send us the details from task logs? Thanks, Aniket On Fri, Jan 6, 2012 at 2:53 AM, Bhavesh Shah wrote: > Hello, > > hive> FROM ( >> FROM subset >> MAP subset.patient_mrn, subset.encounter_date >> USING 'q1.txt' >> AS mp1, mp2 >> CLUSTER BY mp1)

Re: How to write Block of queries in Hive?

2012-01-04 Thread Aniket Mokashi
Hi Bhavesh, [moving discussion to hive user list] I would suggest you to send your discussion to hive user list in order to reach a broader audience. As per my understanding, in the query- map_script and reduce_script are custom scripts that run as a streaming jobs. You are asking hive to run ma

Re: Stored Procedure in Hive

2011-12-28 Thread Aniket Mokashi
Hi, Stored procedures usually have variety of applications. What exactly are you trying to achieve? Usually, people wrap their procedural logic in other programming languages (python, shell). You can also take a look at Hcatalog if you want MR-tools interop. ~Aniket On Wed, Dec 28, 2011 at 10:

Re: Problem in running Hive Queries

2011-12-01 Thread Aniket Mokashi
out. > Thanks. > > -Original Message- > From: Aniket Mokashi [mailto:aniket...@gmail.com] > Sent: Friday, December 02, 2011 11:46 AM > To: dev@hive.apache.org > Subject: Re: Problem in running Hive Queries > > you should open > /tmp/Bhavesh.Shah/hive_job_log_Bhavesh.S

Re: Problem in running Hive Queries

2011-12-01 Thread Aniket Mokashi
you should open /tmp/Bhavesh.Shah/hive_job_log_Bhavesh.Shah_201112021007_2120318983.txt. That will give you more hints. Paste some lines from there on this thread. Thanks, Aniket On Thu, Dec 1, 2011 at 10:11 PM, Bhavesh Shah wrote: > Hi, > > I am new to Hive. I have configured Hadoop and Hive on

[jira] [Created] (HIVE-2617) Insert overwrite table db.tname fails if partition already exists

2011-11-30 Thread Aniket Mokashi (Created) (JIRA)
Components: Metastore Reporter: Aniket Mokashi Insert Overwrite table db.tname fails if partition already exists. For example- insert overwrite table db.tname PARTITION(part='p') select .. from t2 where part='p'; fails if partition 'p' already exist

[jira] [Commented] (HIVE-2361) Add some UDFs which help to migrate Oracle to Hive

2011-11-02 Thread Aniket Mokashi (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2361?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13142542#comment-13142542 ] Aniket Mokashi commented on HIVE-2361: -- This issue depends on Hive-2524 for be