Re: Pointing multiple external tables to the same location

2013-12-17 Thread Navis류승우
Hive uses path to table(or partition) mapping internally (you can see that in MapredWork, etc.), which might caused first table overwritten by other. I didn't tried symlink on hdfs, which could be a solution. 2013/12/12 Petter von Dolwitz (Hem) > Hi, > > I have declared several external table

Re: Limitations in the IndexPredicateAnalyzer

2013-12-17 Thread Navis류승우
IndexPredicateAnalyzer in hive supports AND conjunction only because it's simple. Anyone can implement one that supports conjunctions like OR, CASE, etc. if needed. If you might provide that to hive community, it would be really appreciated. ps. There is a draft patch handling OR conjuncted predic

Re: metastore (mysql) connection problems - hive v0.12

2013-12-17 Thread Richard Nadeau
Hi Stephen, Try increasing the max connections limit in MySQL. I ran into a similar problem and this resolved things after a Hive 0.12 upgrade. You can increase the connection limit without a restart, but pay attention to other settings as well so that you don't over allocate resources on your db

metastore (mysql) connection problems - hive v0.12

2013-12-17 Thread Stephen Sprague
hi guys, I'm pretty much at my wits end on this one. i'm using hive v0.12 against a mysql metastore. the error manifests itself (mostly randomly which is the problem) as this error in the client: 2013-12-17 16:54:03,158 ERROR metastore.RetryingRawStore (RetryingRawStore.java:invoke(146)) - JDO d

RE: Upgrading Hive 0.7/0.8/0.9 to Hive 0.10.0

2013-12-17 Thread Nirmal Kumar
Thanks Arun, I will definitely move to the stable Hadoop-2.2.0 and Hive-0.12 versions. All I want to know is whether upgrading\migrating from Hive 0.7/0.8/0.9 to Hive 0.12 requires some changes in the Hive queries or not? If yes where can I get the info? -Nirmal From: Arun C Murthy [mailto:a.

Re: Upgrading Hive 0.7/0.8/0.9 to Hive 0.10.0

2013-12-17 Thread Arun C Murthy
I'd strongly encourage you to go straight to hadoop-2.2.0 (the hadoop-2 GA release). Also, I'd look at hive-0.12 which has been well tested against hadoop-2.2.0. thanks, Arun On Dec 17, 2013, at 12:43 AM, Nirmal Kumar wrote: > Hi All, > > I have migrated from Apache Hadoop 1.2.0 to Apache H

Re: Hive - Issue Converting Text to Orc

2013-12-17 Thread Bryan Jeffrey
Prasanth, I downloaded the binary Hive version from the URL you specified. I untarred the Hive tar, copied in configuration files, and started Hive. I continue to see the same error: [server:10001] hive> describe orc_test; foo int from deserializer bar

Upgrading Hive 0.7/0.8/0.9 to Hive 0.10.0

2013-12-17 Thread Nirmal Kumar
Hi All, I have migrated from Apache Hadoop 1.2.0 to Apache Hadoop 2.1.0-beta and now I want to migrate the Hive version(0.10.0 +) as well from an older version(0.7/0/8/0.9). This is since the support for Hive to work on YARN in Hadoop 0.23 and 2.x releases has been supported since 0.10.0. I w