Re: Reg: Request write access to the Hive wiki

2020-08-05 Thread Ashutosh Chauhan
Provided write access to wiki. Welcome to the project. On Wed, Aug 5, 2020 at 9:09 AM Sai Hemanth Gantasala < saihema...@cloudera.com> wrote: > Hi admin, > > I'm a Hive developer and I would like to request for write access to the > Hive wiki page. > Confluence User Name: saihemanth > Thanks in

Re: Hive wiki page write access

2020-07-31 Thread Ashutosh Chauhan
Added you Feng Lu. Welcome to the project! On Thu, Jul 30, 2020 at 10:53 PM Feng Lu wrote: > Hi, > > Can someone please grant me write access to the Hive Wiki? > Thank you! > > account_id: fenglu_g. > > Feng >

Re: Jira Doc Access

2020-04-14 Thread Ashutosh Chauhan
What's your user id on Hive wiki? On Tue, Apr 14, 2020 at 11:24 AM ron williams wrote: > Same request please? > Thanks, Ron. > > On Tuesday, April 14, 2020, David Mollitor wrote: > >> Thanks Ashutosh! >> >> On Mon, Apr 13, 2020 at 12:27 PM Ashutosh Chauhan >

Re: Jira Doc Access

2020-04-13 Thread Ashutosh Chauhan
Hi David, Added you to Hive wiki. Thanks, Ashutosh On Mon, Apr 13, 2020 at 6:39 AM David Mollitor wrote: > Hello Team, > > Is anyone able to grant me access to the Apache Hive Wiki (dmollitor) ? > > Also, is there any discussion/interest in moving docs into the git repo? > > Thanks! >

Re: Request write access to the Hive wiki

2020-04-13 Thread Ashutosh Chauhan
Hi Zhihua, Added you to Hive wiki. Thanks, Ashutosh On Mon, Apr 13, 2020 at 4:50 AM dengzhhu653 wrote: > Hi, > > I would like to get write access to the Hive wiki to update some docs. > UserName: zhihuadeng > > Thanks, > Zhihua Deng > > > >

Re: Request write access to Hive wiki

2019-09-13 Thread Ashutosh Chauhan
Done. You now have write access. Welcome Steve to the project and happy wiki editing! On Thu, Sep 12, 2019 at 10:40 AM Stephen Carlin wrote: > Hi, as the subject says, I'd like write access to the Hive Wiki > > My confluence username is scarlin > > Thanks! > > Steve >

Re: Request write access to the Hive wiki

2018-04-29 Thread Ashutosh Chauhan
Hi Nishant, Thanks for your interest in updating our docs. I just granted you write access on cwiki. Thanks, Ashutosh On Tue, Apr 24, 2018 at 11:23 AM, Nishant Bangarwa wrote: > Need to edit druid integration docs. > Please grant account "NishantBangarwa" email id -

Re: Hive Druid SQL

2018-04-09 Thread Ashutosh Chauhan
Hi Amit, Yes only mysql and postgres are supported for druid metadata storage. Thats because Druid only supports these. You mentioned that Hive and Druid are working independently. Which metadata storage your Druid install is using? Thanks, Ashutosh On Mon, Apr 9, 2018 at 7:39 PM, Lefty

Re: hive 2.1.0 + drop view

2016-08-26 Thread Ashutosh Chauhan
Its a bug in DataNucleus. See discussion on : https://issues.apache.org/jira/browse/HIVE-14322 On Fri, Aug 26, 2016 at 1:34 PM, Mich Talebzadeh wrote: > Actually I don't understand why they have defined TBL_NAME and TBL_TYPE as > NVARCHAR (this is from Sybase similar

[ANNOUNCE] New PMC Member : Pengcheng

2016-07-17 Thread Ashutosh Chauhan
> > Hello Hive community, > > I'm pleased to announce that Pengcheng Xiong has accepted the Apache Hive > PMC's > invitation, and is now our newest PMC member. Many thanks to Pengcheng for > all of his hard work. > > Please join me congratulating Pengcheng! > > Best, > Ashutosh > (On behalf of the

[ANNOUNCE] New PMC Member : Jesus

2016-07-17 Thread Ashutosh Chauhan
Hello Hive community, I'm pleased to announce that Jesus Camacho Rodriguez has accepted the Apache Hive PMC's invitation, and is now our newest PMC member. Many thanks to Jesus for all of his hard work. Please join me congratulating Jesus! Best, Ashutosh (On behalf of the Apache Hive PMC)

Re: [VOTE] Bylaws change to allow some commits without review

2016-04-24 Thread Ashutosh Chauhan
+1 PS: Some of us are trying to enable travis-ci for Hive over on https://issues.apache.org/jira/browse/HIVE-10293 Since travis-ci limits build time to ~30 mins, we can't run our full test suite on it. But, it might make sense to use that infra for commits discussed here. In that scenario a

Re: Hive wiki write access request

2016-04-06 Thread Ashutosh Chauhan
Done. Thanks, Ashutosh On Wed, Apr 6, 2016 at 6:22 AM, Random Suit wrote: > Putting in a request for write access on the Hive wiki. My confluence > username is "therandomsuit". > > Thanks. >

[ANNOUNCE] New PMC Member : John Pullokkaran

2015-11-24 Thread Ashutosh Chauhan
On behalf of the Hive PMC I am delighted to announce John Pullokkaran is joining Hive PMC. John is a long time contributor in Hive and is focusing on compiler and optimizer areas these days. Please give John a warm welcome to the project! Ashutosh

Re: [ANNOUNCE] New Hive PMC Chair - Ashutosh Chauhan

2015-10-05 Thread Ashutosh Chauhan
hu, Sep 17, 2015 at 1:09 AM, Carl Steinbach <c...@apache.org> wrote: > >> I am very happy to announce that Ashutosh Chauhan is taking over as the >> new VP of the Apache Hive project. Ashutosh has been a longtime contributor >> to Hive and has played a pivotal role in

Re: Force users to specify partition indexes in queries

2015-09-30 Thread Ashutosh Chauhan
able it. > > Is there a way around this? or my only option is to patch at hive server > code? > > On Wed, Sep 30, 2015 at 2:28 AM, Sathi Chowdhury < > sathi.chowdh...@lithium.com> wrote: > >> hive.exec.dynamic.partition.mode=strict ,seems does the same thing. >&g

Re: Force users to specify partition indexes in queries

2015-09-29 Thread Ashutosh Chauhan
set hive.mapred.mode = strict; This will fail query if query doesnt specify filter containing partitioning column. On Tue, Sep 29, 2015 at 10:56 AM, Smit Shah wrote: > Hey, > > We have exposed hive console to our org via command line and through Hue > ui. However, we are

Re: Wrong results from join query in Hive 0.13 and also 1.0 with reproduce.

2015-09-02 Thread Ashutosh Chauhan
bove reproduce did not have that clause. > > > > On Wed, Sep 2, 2015 at 2:24 AM, Ashutosh Chauhan <hashut...@apache.org> > wrote: > >> https://issues.apache.org/jira/browse/HIVE-10841 >> >> Thanks, >> Ashutosh >> >> On Tue, Sep 1, 2015 a

Re: Wrong results from join query in Hive 0.13 and also 1.0 with reproduce.

2015-09-02 Thread Ashutosh Chauhan
https://issues.apache.org/jira/browse/HIVE-10841 Thanks, Ashutosh On Tue, Sep 1, 2015 at 6:00 PM, Jim Green wrote: > Seems Hive 1.2 fixed this issue. But not sure what is the JIRA related and > the possibility to backport this fix into Hive 0.13? > > > On Tue, Sep 1, 2015

Re: Request write access to the Hive wiki

2015-08-24 Thread Ashutosh Chauhan
Done. Welcome to Hive! On Mon, Aug 24, 2015 at 7:09 PM, Jia, Ke A ke.a@intel.com wrote: Hi, I’d like to have write access to the Hive wiki. My Confluence username is ke.a@intel.com with Full Name “Jia Ke”. Please help me deal with it. Thank you! Regards, Jia Ke

Re: Question about bushy join in hive CBO

2015-05-11 Thread Ashutosh Chauhan
Hi Rossi, Historically, we used LoptOptimizeJoinRule of Calcite to do join reordering. This does a greedy search on join order search space to find a join order which is atleast as good as original join order of query. Goodness being in term of estimated cost and not globally optimal because of

Re: Hive being slow

2015-01-15 Thread Ashutosh Chauhan
will be very fast. -- Abhishek On Thu, Jan 15, 2015 at 1:59 AM, Ashutosh Chauhan hashut...@apache.org wrote: Can you run your query with following config: hive set hive.fetch.task.conversion=none; and run your two queries with this. Lets see if this makes a difference. My expectation

Re: NegativeArraySizeException in table join

2015-01-15 Thread Ashutosh Chauhan
Seems like you are hitting into : https://issues.apache.org/jira/browse/HIVE-9324 On Thu, Jan 15, 2015 at 1:53 AM, Guodong Wang wangg...@gmail.com wrote: Hi, I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 tables. Here is the sample query. INSERT OVERWRITE TABLE

Re: NegativeArraySizeException in table join

2015-01-15 Thread Ashutosh Chauhan
, Ashutosh Chauhan hashut...@apache.org wrote: Seems like you are hitting into : https://issues.apache.org/jira/browse/HIVE-9324 On Thu, Jan 15, 2015 at 1:53 AM, Guodong Wang wangg...@gmail.com wrote: Hi, I am using hive 0.13.1 and currently I am blocked by a bug when joining 2 tables. Here

Re: Hive being slow

2015-01-14 Thread Ashutosh Chauhan
for this very simple query. * Since this query can only be resolved from HBase, will Hive launch map tasks (last time, I guess I observed no map task getting launched) -- Abhishek On Sat, Jan 10, 2015 at 4:14 AM, Ashutosh Chauhan hashut...@apache.org wrote: Hi Abhishek, How are you determining

Re: Hive being slow

2015-01-09 Thread Ashutosh Chauhan
Hi Abhishek, How are you determining its resulting in full table scan? One way to ascertain that filter got pushed down is to see how many tasks were launched for your query, with and without filter. One would expect lower # of splits (and thus tasks) for query having filter. Thanks, Ashutosh

Re: wiki edit access

2014-09-08 Thread Ashutosh Chauhan
Done. Sorry for delay. Ashutosh On Tue, Sep 2, 2014 at 11:59 AM, Sergey Shelukhin ser...@hortonworks.com wrote: Hi. Can I get wiki edit access for Hive? Confluence username sershe CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it

Re: Reading and Writing with Hive 0.13 from a Yarn application

2014-09-03 Thread Ashutosh Chauhan
Hi Nathan, This was done in https://issues.apache.org/jira/browse/HIVE-6248 Reasoning was to minimize api surface area to users so that they are immune of incompatible changes in internal classes and thus making it easier for them to consume this and not get worried about version upgrade. Seems

Re: Reading and Writing with Hive 0.13 from a Yarn application

2014-09-03 Thread Ashutosh Chauhan
. HCatalog, for instance). All that being said :), the ability to get the block locations (and sizes, if possible) would certainly solve my problems. Thanks, Nathan -- *From:* Ashutosh Chauhan hashut...@apache.org *Sent:* Wednesday, September 3, 2014 9

Re: Help needed: Out of memory with windowing functions

2014-08-20 Thread Ashutosh Chauhan
Hi Furcy, Sorry that you run into this, but this is a non-trivial problem. But, good news is Harish has done some good work in this area. See following links. All this will be available in upcoming release, date for which is under discussion on dev list. 1.

Re: request write access to Hive Wiki

2014-08-14 Thread Ashutosh Chauhan
Hi Chengxiang, Granted write access to wiki to you. Thanks, Ashutosh On Thu, Aug 14, 2014 at 2:38 AM, Li, Chengxiang chengxiang...@intel.com wrote: Hi, I'm working on HIVE-7142 https://issues.apache.org/jira/browse/HIVE-7142 which should document some information on Hive wiki, while I

Re: Requesting write access to the Hive wiki

2014-08-04 Thread Ashutosh Chauhan
Hi Ashish, I added you to confluence. Ashutosh On Sun, Aug 3, 2014 at 9:25 PM, Ashish Singh asi...@cloudera.com wrote: Kindly grant me write access to the Hive wiki, so that I can edit the content. Confluence username: asingh -- Regards, Ashish

Re: Write access to wiki

2014-06-27 Thread Ashutosh Chauhan
Done. On Fri, Jun 27, 2014 at 6:26 PM, Sudarshan Rangarajan tr.sudars...@gmail.com wrote: 'tr.sudarshan

Re: edit permissions to wiki

2014-06-26 Thread Ashutosh Chauhan
Done. Thanks, Nitin for your help in improving Hive wiki! On Tue, Jun 24, 2014 at 12:57 PM, Nitin Pawar nitinpawar...@gmail.com wrote: nitinpawar432

Re: Request for Write Access to Hive Wiki

2014-03-31 Thread Ashutosh Chauhan
Done. Thanks, Anthony for helping out to improve our documentation. Ashutosh On Mon, Mar 31, 2014 at 10:03 AM, Anthony Hsu a...@linkedin.com wrote: Hi, Could somebody grant me write access to the Hive wiki? I'd like to update some outdated information on the Hive

Re: Write Access to Wiki to edit HiveServer2 Clients page

2014-02-18 Thread Ashutosh Chauhan
Hi Tsuyoshi, I added you to Hive cwiki. Feel free to contribute. Thanks, Ashutosh On Mon, Feb 17, 2014 at 11:41 PM, Tsuyoshi OZAWA ozawa.tsuyo...@gmail.comwrote: Hi, I'd like to contribute update Hive's wiki. Could you give me a permission to write it? As described in HIVE-4232, we need

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

2014-01-19 Thread Ashutosh Chauhan
I will echo Thejas's concern w.r.t RC voting. Usually it takes 2-3 rounds of RC and folks generally tend to vote towards end of cycle. So, if we increase it to 7 days, we are looking at 21 days (in worst case) to get a release out, which may not be what we want. So, for RC vote my suggestion will

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

2013-12-27 Thread Ashutosh Chauhan
Proposed changes look good to me, both suggested by Carl and Thejas. Another one I would like to add for consideration is: 24 hour rule between +1 and commit. Since this exists only in Hive (no other apache project which I am aware of) this surprises new contributors. More importantly, I have seen

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

2013-12-27 Thread Ashutosh Chauhan
. I think having a waiting period of 24 hours between a jira being made 'patch available' and committing is better and sufficient. On Fri, Dec 27, 2013 at 11:44 AM, Ashutosh Chauhan hashut...@apache.org wrote: Proposed changes look good to me, both suggested by Carl and Thejas

Re: requesting access to hive confluence wiki

2013-12-10 Thread Ashutosh Chauhan
Sorry, I missed this one. Xiao you should now have perms to edit cwiki. Thanks, Ashutosh On Tue, Dec 10, 2013 at 6:26 PM, Navis류승우 navis@nexr.com wrote: Is there someone who knows how to do this? 2013/11/30 Xiao Meng xi...@simba.com Hi, I would like update/fix some contents on

Re: request Hive wiki write access

2013-10-29 Thread Ashutosh Chauhan
integration -Mikhail 2013/10/28, Ashutosh Chauhan hashut...@apache.org: Hi Eric, Added you as a contributor to Hive wiki. Thanks, Ashutosh On Mon, Oct 28, 2013 at 4:39 PM, Eric Hanson (SQL SERVER) eric.n.han...@microsoft.com wrote: Hi, I would like write access

Re: request Hive wiki write access

2013-10-28 Thread Ashutosh Chauhan
Hi Eric, Added you as a contributor to Hive wiki. Thanks, Ashutosh On Mon, Oct 28, 2013 at 4:39 PM, Eric Hanson (SQL SERVER) eric.n.han...@microsoft.com wrote: Hi, I would like write access to the Hive wiki to add documentation on how to used vectorized query. Can the owner please add

Re: request Hive wiki write access

2013-10-28 Thread Ashutosh Chauhan
Hi Mikhail, Sure, but first you first need to create an account on https://cwiki.apache.org/confluence/display/Hive/Home Once you have done that, than let me know your cwiki id and I will add you as a contributor. Ashutosh On Mon, Oct 28, 2013 at 5:55 PM, Mikhail Antonov

Re: Operators and || do not work

2013-09-19 Thread Ashutosh Chauhan
I have not tested it on historical versions, so don't know on which versions it used to work (if ever), but possibly antlr upgrade [1] may have impacted this. [1] : https://issues.apache.org/jira/browse/HIVE-2439 Ashutosh On Thu, Sep 19, 2013 at 4:52 AM, amareshwari sriramdasu

Re: Access

2013-09-04 Thread Ashutosh Chauhan
Added. Thanks, Ellen for helping in improving hive documentation. Ashutosh On Wed, Sep 4, 2013 at 3:13 PM, Ellen Evans j...@hortonworks.com wrote: -- Forwarded message -- From: Ellen Evans j...@hortonworks.com Date: Wed, Sep 4, 2013 at 3:11 PM Subject: Access To:

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Ashutosh Chauhan
Fix in very related area has been checked in trunk today : https://issues.apache.org/jira/browse/HIVE-5129 Likely that will fix your issue. Can you try latest trunk? Ashutosh On Tue, Sep 3, 2013 at 2:03 PM, Nathanial Thelen n...@natethelen.comwrote: I am running Hive in EMR and since

Re: Problems with 0.11, count(DISTINCT), and NPE

2013-09-03 Thread Ashutosh Chauhan
Not sure about EMR. Your best bet is to ask on EMR forums. Thanks, Ashutosh On Tue, Sep 3, 2013 at 2:18 PM, Nathanial Thelen n...@natethelen.comwrote: Is there a way to run a patch on EMR? Thanks, Nate On Sep 3, 2013, at 2:14 PM, Ashutosh Chauhan hashut...@apache.org wrote: Fix in very

Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

2013-08-29 Thread Ashutosh Chauhan
Thanks Agatea for digging in. Seems like you have hit a bug. Would you mind opening a jira and adding your findings to it. Thanks, Ashutosh On Thu, Aug 29, 2013 at 11:22 AM, agateaaa agate...@gmail.com wrote: Sorry hit send too soon ... Hi All: Put some debugging code in

Re: Last time request for cwiki update privileges

2013-08-21 Thread Ashutosh Chauhan
Not able to find this id in cwiki. Did you create an account on cwiki.apache.org On Wed, Aug 21, 2013 at 2:59 PM, Mikhail Antonov olorinb...@gmail.comwrote: mantonov

Re: Last time request for cwiki update privileges

2013-08-20 Thread Ashutosh Chauhan
Hi Sanjay, Really sorry for that. I apologize for the delay. You are added now. Feel free to make changes to make Hive even better! Thanks, Ashutosh On Tue, Aug 20, 2013 at 2:39 PM, Sanjay Subramanian sanjay.subraman...@wizecommerce.com wrote: Hey guys I can only think of two reasons

Re: Write access for the wiki

2013-07-30 Thread Ashutosh Chauhan
Mark, Do you have an account on hive cwiki. Whats your id ? Thanks, Ashutosh On Tue, Jul 30, 2013 at 1:06 PM, Mark Wagner wagner.mar...@gmail.comwrote: Hi all, Would someone with the right permissions grant me write access to the Hive wiki? I'd like to update some information on the Avro

Re: Write access for the wiki

2013-07-30 Thread Ashutosh Chauhan
Is that your cwiki id ? I am not seeing it there. Remember cwiki is separate than jira account. Ashutosh On Tue, Jul 30, 2013 at 1:40 PM, Mark Wagner wagner.mar...@gmail.comwrote: My id is mwagner. Thanks! On Tue, Jul 30, 2013 at 1:36 PM, Ashutosh Chauhan hashut...@apache.orgwrote: Mark

Re: Write access for the wiki

2013-07-30 Thread Ashutosh Chauhan
Done. Added you as contributor. Happy Documenting !! Ashutosh On Tue, Jul 30, 2013 at 2:15 PM, Mark Wagner wagner.mar...@gmail.comwrote: Yes, I created it right before emailing the list: https://cwiki.apache.org/confluence/display/~mwagner On Tue, Jul 30, 2013 at 1:45 PM, Ashutosh Chauhan

Re: Help in ROW_NUMBER() OVER (PARTITION BY) in Hive

2013-07-02 Thread Ashutosh Chauhan
Windowing functions (over clause) were introduced in 0.11 You need to upgrade to 0.11 to make use of them. Ashutosh On Tue, Jul 2, 2013 at 7:19 AM, dyuti a hadoop.hiv...@gmail.com wrote: Hi Experts, I'm working with Teradata query conversion to hive environment (Hive version 0.10.0).The

[VOTE] Apache Hive 0.11.0 Release Candidate 1

2013-04-30 Thread Ashutosh Chauhan
Hey all, Based on feedback from folks, I have respun release candidate, RC1. Please take a look. It basically fixes the size bloat of tarball. Source tag for RC1 is at: https://svn.apache.org/repos/asf/hive/tags/release-0.11.0-rc1 Source tar ball and convenience binary artifacts can be found

[VOTE] Apache Hive 0.11.0 Release Candidate 0

2013-04-29 Thread Ashutosh Chauhan
Hey all, I am excited to announce availability of Apache Hive 0.11.0 Release Candidate 0 at: http://people.apache.org/~hashutosh/hive-0.11.0-rc0/ Maven artifacts are available here: https://repository.apache.org/content/repositories/orgapachehive-154/ This release has many goodies including

Re: builtins submodule - is it still needed?

2013-04-05 Thread Ashutosh Chauhan
I haven't used it myself anytime till now. Neither have met anyone who used it or plan to use it. Ashutosh On Thu, Apr 4, 2013 at 2:01 PM, Travis Crawford traviscrawf...@gmail.comwrote: Hey hive gurus - Is the builtins hive submodule in use? The submodule was added in HIVE-2523 as a

Re: why apache hive 0.10 document not found?

2013-03-08 Thread Ashutosh Chauhan
This is now fixed via HIVE-4074. Docs are now online again. Thanks, Gunther! Ashutosh On Tue, Mar 5, 2013 at 6:42 PM, 周梦想 abloz...@gmail.com wrote: from version 0.80, the release document is not found. http://hive.apache.org/docs/r0.10.0/ Not Found The requested URL /docs/r0.10.0/ was not

Re: ROW_NUMBER() equivalent in Hive

2013-02-21 Thread Ashutosh Chauhan
Kumar, If you are willing to be on bleeding edge, this and many other partitioning and windowing functionality some of us are developing in a branch over at: https://svn.apache.org/repos/asf/hive/branches/ptf-windowing Check out this branch, build hive and than you can have row_number()

Re: ROW_NUMBER() equivalent in Hive

2013-02-21 Thread Ashutosh Chauhan
, I am interested / reviewing your windowing feature. Can you be more specific about which (a) tests and (b) src files constitute your additions (there are lots of files there ;) ) thanks stephen boesch 2013/2/21 Ashutosh Chauhan hashut...@apache.org Kumar, If you are willing

Re: [VOTE] Amend Hive Bylaws + Add HCatalog Submodule

2013-01-28 Thread Ashutosh Chauhan
Measure 1: +1 Measure 2: +1 Ashutosh On Mon, Jan 28, 2013 at 11:48 AM, Carl Steinbach c...@apache.org wrote: Measure 1: +1 (binding) Measure 2: +1 (binding) On Mon, Jan 28, 2013 at 11:47 AM, Carl Steinbach c...@apache.org wrote: I am calling a vote on the following two measures.

[ANNOUNCE] Apache Hive 0.10.0 Released

2013-01-11 Thread Ashutosh Chauhan
The Apache Hive team is proud to announce the the release of Apache Hive version 0.10.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in distributed storage. Built on top of Apache Hadoop (TM), it provides: * Tools to enable easy data

Re: ASF HiveServer2 release plan !!

2013-01-08 Thread Ashutosh Chauhan
Hi Manish, Currently the blocker for HiveServer2 in ASF is https://issues.apache.org/jira/browse/HIVE-3785 Patch there outlines changes HS2 requires in existing hive codebase. That patch is currently under review. Once thats reviewed and checked-in than remaining of HS2 patch will made it in

Re: hiveserver leak zookeeper connections?

2013-01-05 Thread Ashutosh Chauhan
We have found one source of leak which we think we have fixed. https://issues.apache.org/jira/browse/HIVE-3723 This is a part of hive-0.10 RC0 http://people.apache.org/~hashutosh/hive-0.10.0-rc0/ You can try hive from there and see if this fixes this connection leaking problem. Thanks, Ashutosh

Re: MapJoin error: .hashtable file not found

2012-11-27 Thread Ashutosh Chauhan
Hi Vivek, I will encourage you to try out latest trunk or hive-0.10 branch. Lots of work has gone in since 0.9 to make Hive work better on Windows. Ashutosh On Tue, Nov 27, 2012 at 11:08 PM, Vivek Mishra vivek.mis...@impetus.co.inwrote: Hi, I am using 0.9.0 hive with Windows 2008 server.

Re: Hive Meta Server (Thrift Server) Failover / Redundancy / Load Balancing

2012-11-13 Thread Ashutosh Chauhan
that patch when using the secured one? Again thanks your help !! Regards, Manish On Thu, Nov 8, 2012 at 9:39 AM, Ashutosh Chauhan hashut...@apache.orgwrote: Hi Manish, Your understanding is mostly correct, though there is one additional bit. MetastoreClient in current incarnation

Re: Hive Meta Server (Thrift Server) Failover / Redundancy / Load Balancing

2012-11-08 Thread Ashutosh Chauhan
Hi Manish, Your understanding is mostly correct, though there is one additional bit. MetastoreClient in current incarnation don't automatically reconnect in case connection gets dropped for a connected session. As a result, it won't failover active connections. New connections would be fine.

Re: Issue while using hive 0.9

2012-09-17 Thread Ashutosh Chauhan
That won't work. You must use the exact same version which was used while compiling Hive, i.e., 3.0.1 any other version won't work. Look at the classpath of java process of Hive to make sure there is no other version in your classpath. Hope it helps, Ashutosh On Mon, Sep 17, 2012 at 4:40 AM,

Re: Issue while using hive 0.9

2012-09-17 Thread Ashutosh Chauhan
Only thing which is different then usual setups is jdk1.7 Is it possible for you to test with jdk1.6 ? Ashutosh On Mon, Sep 17, 2012 at 10:02 PM, Sarath Chandra sarathchandra.jos...@algofusiontech.com wrote: @Ashutosh I haven't built my hive from sources. I just downloaded the binaries from

Re: Issue while using hive 0.9

2012-09-17 Thread Ashutosh Chauhan
). Changed hadoop conf to use this JDK. java -version prints the 1.6 version. Replaced antlr JAR with the same version as it came in hive binary (3.0.1). Anything else I have to do? Do I need to make any changes in hive-conf folder? On Tuesday 18 September 2012 10:35 AM, Ashutosh Chauhan wrote

Re: 回复: [ANNOUNCE] New PMC member - Ashutosh Chauhan

2012-07-18 Thread Ashutosh Chauhan
2012 15:37:32 +0800 *To: *useruser@hive.apache.org *ReplyTo: * user@hive.apache.org *Subject: *回复: [ANNOUNCE] New PMC member - Ashutosh Chauhan congratulates~! 2012-07-17 -- ** Best Regards Andes ** -- *发件人:*John Sichi *发送时间

Re: Querying HBase Records with null valued-columns using hive

2012-06-02 Thread Ashutosh Chauhan
Hey Sagar, Seems like you have inserted data in your hbase table directly through hbase client and not through hive client. If so, you need https://issues.apache.org/jira/browse/HIVE-1634 to correctly read pre-existing data in hbase. Hive-1634 is available as a part of 0.9 release. So, upgrade to

Re: Behavior of Hive 2837: insert into external tables should not be allowed

2012-06-01 Thread Ashutosh Chauhan
Hi Mark, I understand your concern w.r.t backward compatibility. But as Ed pointed out there is a config variable and by default semantic is unchanged so you can continue to insert into your external table. I have a question though. Why are you creating all your tables as external tables ? Why

Re: Setup for contributing to Hive from MAC

2012-05-31 Thread Ashutosh Chauhan
https://cwiki.apache.org/confluence/display/Hive/HowToContribute will help you get started. Thanks, Ashutosh On Thu, May 31, 2012 at 8:55 AM, Mapred Learn mapred.le...@gmail.comwrote: Hi, Does anyone know how to set up apache hive on MAC to contribute and fix JIRAs ? Thanks, JJ Sent from

What is hive doing wrong?

2012-05-26 Thread Ashutosh Chauhan
Actually, whats more interesting is Shark. I attended one of the meetup here in Bay Area couple of months back where Chris presented Shark. Had a follow-up conversation with Matei after that. They have an interesting goal of making (unaltered) Hive queries run on Spark running on cluster managed

Re: Is there a metastore schema script for postgresql for Hive version 0.9.0

2012-05-12 Thread Ashutosh Chauhan
Hi Xiaobo, It depends on what your current setup is: a) If you are trying Hive for the first time, then you don't necessarily need to create schema in postgres upfront. As wd suggested, datanucleus (ORM used by Hive) can autocreate the schema if it doesn't exist. b) If you are already using Hive

Re: does hive 0.9 supported hbase 0.90?

2012-05-09 Thread Ashutosh Chauhan
Hi Ransom, Hive 0.9 requires HBase 0.92 to work correctly. Thanks, Ashutosh On Wed, May 9, 2012 at 12:47 AM, Hezhiqiang (Ransom) ransom.hezhiqi...@huawei.com wrote: In 0.8.1 version ,it’s ok But in 0.9 When I run selelct * from tbl, it was faild. ** ** Exception in

Re: does hive 0.9 supported hbase 0.90?

2012-05-09 Thread Ashutosh Chauhan
notes. ** ** Best regards Ransom. ** ** *From:* Ashutosh Chauhan [mailto:hashut...@apache.org] *Sent:* Wednesday, May 09, 2012 4:29 PM *To:* user@hive.apache.org *Cc:* Wenzaohua *Subject:* Re: does hive 0.9 supported hbase 0.90? ** ** Hi Ransom, ** ** Hive

[ANNOUNCE] Apache Hive 0.9.0 Released

2012-04-30 Thread Ashutosh Chauhan
The Apache Hive team is proud to announce the the release of Apache Hive version 0.9.0. The Apache Hive (TM) data warehouse software facilitates querying and managing large datasets residing in distributed storage. Built on top of Apache Hadoop (TM), it provides: * Tools to enable easy data

Re: Thrift service + zklocks + time = death

2012-04-11 Thread Ashutosh Chauhan
Premise of the locking is that in well-behaved queries you will obtain a lock at the start of the query and then relinquish it at the end of query. Since, locks are lease-based, in badly-behaving queries after lease expires, lock will be relinquished. Are you are NPE for same repeated query

Re: Lag function in Hive

2012-04-11 Thread Ashutosh Chauhan
Hey Harish, Awesome work on SQL Windowing. Judging from participation on this thread, it seems windowing is of sizable interest to Hive community. Would you consider contributing your work upstream in Hive? If its in Hive contrib, it will be accessible to lot of folks using Hive out of box.

Re: Hive query on existing HBase table

2012-04-07 Thread Ashutosh Chauhan
Hi Vishal, Not through a released version of Hive. But, if you are willing to build hive from svn trunk, you will be able to do query on existing hbase tables. Or, you can wait for 0.9 to be released. Hope it helps, Ashutosh On Sat, Apr 7, 2012 at 11:43, Vishal M. Katkar vishal...@gmail.com

Re: Hive Web Interface boots-up fine but doest show the webapp (Hive 0.8.1)

2012-02-16 Thread Ashutosh Chauhan
Try: 127.0.0.1:9900/hwi On Thu, Feb 16, 2012 at 19:53, Abhishek Parolkar abhis...@viki.com wrote: Hi there, I just want to have a simple hive interface with HWI. when I start it with hive --service hwi' it boots up but when I visit the index.jsp it always complain 404. This is what I

Re: Hive projects for Google Summer of code 2012 ?

2012-02-04 Thread Ashutosh Chauhan
Hey Bharath, Great to see your enthusiasm for Hive! I would be happy to mentor you for the project. For the start, you can take a look at https://cwiki.apache.org/confluence/display/Hive/Roadmap for a list of open projects in Hive. The document is bit dated, so some of those projects may not be

Re: Hive installation problem: java.lang.NoSuchFieldError: type

2011-11-10 Thread Ashutosh Chauhan
We are planning to upgrade antlr version which should fix this issue. https://issues.apache.org/jira/browse/HIVE-2439 Ashutosh 2011/11/10 Nicolas Lalevée nicolas.lale...@hibnet.org Le 4 nov. 2011 à 17:19, Jian Fang a écrit : Hi, I installed hive 0.7.1 to work with Hadoop 0.20.2. I

Re: Hive build error - Ant related

2011-11-10 Thread Ashutosh Chauhan
Following should help: 1) rm -rf ~/.ant/cache 2) rm -rf ~/.ivy2/cache 3) ant clean ant package. Also make sure you are using ant 1.8+ Hope it helps, Ashutosh On Wed, Nov 9, 2011 at 14:14, Vandana Ayyalasomayajula avand...@yahoo-inc.com wrote: Hi All, When I run ant clean package in hive

Re: Latest hive source code

2011-10-27 Thread Ashutosh Chauhan
You can get the latest hive trunk source from here: http://svn.apache.org/repos/asf/hive/trunk/ Hope it helps, Ashutosh On Thu, Oct 27, 2011 at 20:01, trang van anh anh...@vtc.vn wrote: Thanks for your response, i check your link sent and i see that latest source code version 0.7.1., But

Re: UnixODBC and Hive setup

2011-10-26 Thread Ashutosh Chauhan
When I run the ant build, it fails because it can’t find header file fb303_types.h. Any idea where this file should come from? You need to build fb303 for this. Go to the dir where you untarred thrift tar ball. Then, cd contrib/fb303 . Then ./bootstrap.sh configure make make install. Bit more

Re: UnixODBC and Hive setup

2011-10-26 Thread Ashutosh Chauhan
** ** ** ** ** ** ** ** *From:* Ashutosh Chauhan [mailto:hashut...@apache.org] *Sent:* 26 October 2011 17:27 *To:* user@hive.apache.org *Subject:* Re: UnixODBC and Hive setup ** ** When I run the ant build, it fails because it can’t find header file fb303_types.h. Any idea where

Re: Running hive on large number of files in S3

2011-10-20 Thread Ashutosh Chauhan
Hey Thulasi, There are two factors which may affect job startup time in case of large number of partitions: a) Getting partition info from metastore: Hive stores metadata about each partiton in metastore. Depending on number of partitions, it needs to fetch, that can take some time. b) Input

Re: One Schema Per Partition? (Multiple schemas per table?)

2011-10-06 Thread Ashutosh Chauhan
I do something wrong? On Mon, Aug 29, 2011 at 10:46 PM, Ashutosh Chauhan hashut...@apache.orgwrote: Hi Tim, I figured that both reading the code and manual. I don't think its explicitly documented anywhere, so it will be great if you document this. This page looks right place where

Re: HBase and Hivehandler compatibly

2011-09-14 Thread Ashutosh Chauhan
Hi Naila, That combination should work fine. Is there any specific problem you are encountering ? Hope it helps, Ashutosh On Tue, Sep 13, 2011 at 22:28, Naila karim 09msitnka...@seecs.edu.pkwrote: Dear All, Hello I have Hadoop 0-20.2 append version and HBase-0.90.3. I am trying to build

Re: Change in serdeproperties does not update existing partitions

2011-09-14 Thread Ashutosh Chauhan
have to convert the whole history? Best, Maxime On Tue, Sep 13, 2011 at 7:03 PM, Ashutosh Chauhan hashut...@apache.orgwrote: Hey Maxime, Yeah, thats intended behavior. After you do alter on table, all subsequent actions on table and partitions will inherit from it. If you want to modify

Re: Hive issue

2011-09-13 Thread Ashutosh Chauhan
+ user@hive Siddharth, java.sql.SQLException: Method not supported at org.apache.hadoop.hive.jdbc.HiveConnection.createStatement(HiveConnection.java:207) Hive's jdbc implementation is not fully jdbc compliant yet and doesn't support all the features. Hope it helps, Ashutosh On Tue, Sep 13,

Re: Pentaho issue with hive

2011-09-12 Thread Ashutosh Chauhan
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.io.Writable Seems like you have classpath issues. Make sure hadoop-core.jar (or whatever is the name of your hadoop jars) are in classpath Hope it helps, Ashutosh On Mon, Sep 12, 2011 at 09:20, Siddharth Tiwari

Re: CREATE INDEX

2011-09-12 Thread Ashutosh Chauhan
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDropIndexhas DDL commands using which you can create and manipulate indices in Hive. Hope it helps, Ashutosh On Mon, Sep 12, 2011 at 05:46, Adriaan Tijsseling adri...@tijsseling.comwrote: Does anyone

Re: Hive thrift interface and user permissions / user auditing

2011-09-07 Thread Ashutosh Chauhan
)? Does secure mode suport hive JDBC? Thanks! Koert On Tue, Sep 6, 2011 at 11:47 AM, Ashutosh Chauhan hashut...@apache.orgwrote: Hey Koert, I am assuming 'thrift' is the name of user through which thrift metastore is running. I also assume you are running in unsecure mode. If you run

Re: Hive thrift interface and user permissions / user auditing

2011-09-06 Thread Ashutosh Chauhan
Hey Koert, I am assuming 'thrift' is the name of user through which thrift metastore is running. I also assume you are running in unsecure mode. If you run with security turned on, meaning secure hadoop cluster with secure thrift server, you will see the name of the original user. This is so

Re: One Schema Per Partition? (Multiple schemas per table?)

2011-08-29 Thread Ashutosh Chauhan
give the syntax you give (from quoted, assuming after I test it, it works). [1] https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTable%2FPartitionStatements On Wed, Aug 24, 2011 at 6:14 PM, Ashutosh Chauhan hashut...@apache.orgwrote: Hey Tim, Hive

Re: How to skip the malformatted records while loading data

2011-08-24 Thread Ashutosh Chauhan
One possibility is to filter out NULLs, something like following: hive select * from tb where id != NULL or pref != NULL or zip != NULL; This is not most efficient, but will work. 2011/8/18 XieXianshan xi...@cn.fujitsu.com Hi,everyone, Is there an option to ignore malformatted records while

  1   2   >