Re: Querying hive without providing schema during create table for JSON data

2015-09-10 Thread Muthu Pandi
You can use Apache Drill to query Json data without creating the schema but you cant in Hive. http://drill.apache.org/docs/querying-json-files/ *RegardsMuthupandi.K* *muthupandi.strikingly.com * Think before you print. On Thu, Sep 10, 2015 at 9:16 PM,

Re: java.io.FileNotFoundException: File does not exist (nexr-hive-udf-0.2-SNAPSHOT.jar)

2014-12-17 Thread Muthu Pandi
Hi Arthur Have a look at here https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-PermanentFunctions *RegardsMuthupandi.K* Think before you print. On Wed, Dec 17, 2014 at 2:53 PM, arthur.hk.c...@gmail.com arthur.hk.c...@gmail.com wrote: Hi,

Re: Can't integrate Elasticsearch with Hive

2014-11-27 Thread Muthu Pandi
Hi Atul Check your typo tblproperties('es.resources' = 'employee/address') need to be es.resource as it rightly indicated in the Error. *RegardsMuthupandi.K* Think before you print. On Fri, Nov 28, 2014 at 3:43 AM, Edward Capriolo edlinuxg...@gmail.com wrote: Because the elastic

Re: Can't integrate Elasticsearch with Hive

2014-11-27 Thread Muthu Pandi
*From:* Muthu Pandi [mailto:muthu1...@gmail.com] *Sent:* Thursday, November 27, 2014 9:08 PM *To:* user@hive.apache.org *Subject:* Re: Can't integrate Elasticsearch with Hive Hi Atul Check your typo tblproperties('es.resources' = 'employee/address') need to be es.resource

Re: Unix script for identifying current active namenode in a HA cluster

2014-11-04 Thread Muthu Pandi
Good work Devopam Mittra. *RegardsMuthupandi.K* Think before you print. On Wed, Nov 5, 2014 at 12:31 PM, Nitin Pawar nitinpawar...@gmail.com wrote: +1 If you can optionally add hadoop home directory in the script and use that in path, it can be used out of the box. Also can you share

Re: oozie installation error

2014-09-25 Thread Muthu Pandi
Hi Rahul Distro error may occur while using this command bin/mkdistro.sh -DskipTests instead of that use mvn clean package assembly:single -P hadoop-2 -DskipTests if you are building against hadoop 2 it resolved the distro error. For more info follow http://gauravkohli.com/category/oozie/;

Re: oozie installation error

2014-09-25 Thread Muthu Pandi
replace hadoop-2 with hadoop-1 *RegardsMuthupandi.K* Think before you print. On Thu, Sep 25, 2014 at 4:48 PM, Rahul Channe drah...@googlemail.com wrote: Hi Muthu, I am trying to build oozie against hadoop 1 On Thursday, September 25, 2014, Muthu Pandi muthu1...@gmail.com wrote: Hi

Re: Mysql - Hive Sync

2014-09-06 Thread Muthu Pandi
out for you. On Tue, Sep 2, 2014 at 11:03 PM, Muthu Pandi muthu1...@gmail.com wrote: This cant be done since insert update delete are not supported in hive. Mysql Applier for Hadoop package servers the same purpose of the prototype tool which i intended to develop. link for Mysql Applier

Re: Mysql - Hive Sync

2014-09-03 Thread Muthu Pandi
*Regards Muthupandi.K* [image: Picture (Device Independent Bitmap)] On Wed, Sep 3, 2014 at 10:35 AM, Muthu Pandi muthu1...@gmail.com wrote: Yeah but we cant make it to work as near real time. Also my table doesnt have like 'ID' to use for --check-column that's why opted out of sqoop. *Regards

Mysql - Hive Sync

2014-09-02 Thread Muthu Pandi
Dear All Am developing a prototype of syncing tables from mysql to Hive using python and JDBC. Is it a good idea using the JDBC for this purpose. My usecase will be generating the sales report using the hive, data pulled from mysql using the prototype tool.My data will be around 2GB/day.

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

2014-08-22 Thread Muthu Pandi
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 supp...@lighthadoop.com wrote: We have released a very basic 32-bit VM (VirtualBox Image) for those users who want to