Re: Basic Hadoop 2.3 32-bit VM for general Hadoop Users

Excellent initiative All the Best for the startups *Regards Muthupandi.K* [image: Picture (Device Independent Bitmap)] On Fri, Aug 22, 2014 at 11:38 PM, Support Team wrote: > We have released a very basic 32-bit VM (VirtualBox Image) for those users > who want to get started with Hado

Re: how to alter location where database is point to

Try doing: alter database * *set dbproperties ('hive.warehouse.dir' = ' *newlocation');* --Bala G. On Fri, Aug 22, 2014 at 8:59 AM, Hussain Jamali wrote: > Hi All, > > Can somebody help me with alter command to change the hive database > location in hive 11 > > > > I have tried below command

Re: Load CSV files with embedded map and arrays to Hive

Hey Sushant I looked at the CSV file. The rows are not JSON. >From my limited understanding of what you are looking for , my suggestion >would be to have the input as rows of JSONs instead Example of the first row from your data set will be {"employee":{"name":"John Doe","salary":10,"subor

Re: Passing variables using Hiveconf

Nithin , It worked when i set hive.variable.substitute=true; every time i run this query.. thanks buddy On Fri, Aug 22, 2014 at 1:08 PM, Nitin Pawar wrote: > this is one way > > hive $HIVEPARAMS -hiveconf target="$var1" -hiveconf > mapred.child.java.opts="-server -Xmx1200m -Djava.net.preferIPv

Re: Passing variables using Hiveconf

this is one way hive $HIVEPARAMS -hiveconf target="$var1" -hiveconf mapred.child.java.opts="-server -Xmx1200m -Djava.net.preferIPv4Stack=true" and you need to set this variable set hive.variable.substitute=true; On Fri, Aug 22, 2014 at 9:24 PM, karthik Srivasthava < karthiksrivasth...@gmail.c

Basic Hadoop 2.3 32-bit VM for general Hadoop Users

We have released a very basic 32-bit VM (VirtualBox Image) for those users who want to get started with Hadoop, without worrying about configuration and dependencies. We have used CDH5.1 for this release which contains Hadoop 2.3 (YARN), Pig 0.12, Hive 0.12, Sqoop 1.4.4 along with MySQL with 8

how to alter location where database is point to

Hi All, Can somebody help me with alter command to change the hive database location in hive 11 I have tried below commands both are failing alter database set location ''; alter database location ''; Thanks in advance Hussain Jamali This message and the information contained herein is

Passing variables using Hiveconf

Hi, I am passing substitution variable using hiveconf in Hive.. But i couldnt execute simple queries when i am trying to pass more than one parameter. It throws NoViableAltException - AtomExpression.. Am i missing something.?

Re: doubt about locking mechanism in Hive

IMHO locking support should be turned off by default. I would argue if you are requiring this feature often you may be designing your systems improperly. You really should not have that many situations where you need locking in a write (mostly) once file system. The only time I have ever used it i

doubt about locking mechanism in Hive

Hi, I have some troubles with the locking/concurrency mechanism of Hive when doing a large select and trying to create a table at the same time. My version of Hive is 0.13. What I try to do is the following: 1) In a hive shell: use mydatabase; select * from competence limit 1;