Re: Using SPLIT with DOT(.) delimiter demonstrate funny behavior within a VIEW

2015-08-24 Thread Vivek Veeramani
ease have a look and let us know if that helps. Best , Vivek Veeramani cell : + 1-415 996 7853 On Mon, Aug 24, 2015 at 12:15 PM, Sanjay Subramanian < sanjaysubraman...@yahoo.com> wrote: > Hi guys > > I am using > > Hive version = 0.

Re: ORC Table creation failure

2015-05-21 Thread vivek veeramani
a type? Can you run the SELECT by itself without the CREATE TABLE? > > Abe > > On Wed, May 20, 2015 at 11:23 PM, vivek veeramani < > vivek.veeraman...@gmail.com> wrote: > >> >> Hi , >> >> I'm trying to create a subset table from a master tab

ORC Table creation failure

2015-05-20 Thread vivek veeramani
apReduce CPU Time Spent: 2 days 21 hours 38 minutes 36 seconds 700 msec Greatly appreciate any help or information on this and how to rectify it. -- Thanks , Vivek Veeramani cell : +91-9632 975 975 +91-9895 277 101

Re: Dataset for hive

2015-04-01 Thread vivek veeramani
All, > > I am new to Hive. Just set up a 5 nodes Hadoop environment and want to > have a try on HiveQL. > Is there any dataset I can download to play HiveQL. The dataset should > have several tables some I can write some complex join. About 100G should > be fine. > > Tha

Re: CamelCase using InitCap Function in Hive 0.13

2015-04-01 Thread vivek veeramani
ngh wrote: > > Available in build 1.1.0 > <https://issues.apache.org/jira/browse/HIVE/fixforversion/12329363> > > JIRA : https://issues.apache.org/jira/browse/HIVE-3405 > > > > Regards > Sanjiv Singh > Mob : +091 9990-447-339 > > > On Wed, Apr 1, 2015 at 6:24

CamelCase using InitCap Function in Hive 0.13

2015-04-01 Thread vivek veeramani
shows an invalid function error, and the show functions does not list the function. I'm running Hive 0.13. Is there any setting I need to enable this? Please advice what needs to be done in order to use this function. -- Thanks in advance, Vivek Veeramani cell : +91-9632 975 975 +9