Cannot create an instance of InputFormat class org.apache.hadoop.mapred.TextInputFormat as specified

2012-02-14 Thread Abhishek Parolkar
Hi I just installed Hive 0.8.1 with hadoop 1.0.0 when I run hive query I get "Cannot create an instance of InputFormat class org.apache.hadoop.mapred.TextInputFormat as specified" all the time Here is the full trace http://pastie.org/private/sl8xmyasi7sjkce2wfn9qq I have HADOOP_HOME , HA

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

2012-02-16 Thread Abhishek Parolkar
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 am doing http://screencast.com/t/c5Qm8vnNAaI any pointers? -v_abhi_v

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

2012-02-17 Thread Abhishek Parolkar
hahaha :) not intuitive at all :) Thanks -v_abhi_v On Fri, Feb 17, 2012 at 2:38 PM, Ashutosh Chauhan wrote: > Try: 127.0.0.1:9900/hwi > > > On Thu, Feb 16, 2012 at 19:53, Abhishek Parolkar wrote: > >> >> Hi there, >>I just want to have a simple hive in

Hive CLI (v0.8.1) -e option trowing parse error all the time

2012-02-19 Thread Abhishek Parolkar
Hi All: I am trying to get -e option in hive CLI work for me. Looks like it isn't straight forward. hadoopnode1:~ hadoop$ hive hive> desc temp_logs; OK log_time string namespace string json string ds string hour string Time taken: 2.832 seconds hive> exit; hadoopnode1:~ hadoop$ hive -e "des

Re: Hive CLI (v0.8.1) -f option returns if even if just single query fails

2012-02-19 Thread Abhishek Parolkar
Hi, I have a big list of data to be loaded into hive and I create a .hql file with all load statements. Problem number 1.) This fails with exception in copy files Failed with exception copyFiles: error while checking/creating destination directory!!! FAILED: Execution Error, return code 1 from

Repeatedly getting (java.lang.RuntimeException: Error while reading from task log url)

2012-03-08 Thread Abhishek Parolkar
Hi There! I have been doing an interesting experiment of building mac mini cluster ( http://www.scribd.com/doc/76827185/Mac-Mini-Hadoop-Cluster) I am continuously getting "*Exception in thread "Thread-69" java.lang.RuntimeException: Error while reading from task log ur*l" errors when I run hive

Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
Hi There, I am trying to get dboutput() UDF to work so that it can write result to a PG DB table. ==This is what I did in hive shell== add jar /location/hive_contrib.jar; add jar /location/postgresql9jdbc3.jar; set jdbc.drivers = org.postgresql.Driver; CREATE TEMPORARY FUNCTION dboutpu

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
th sqoop export command. > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > -- > *From: * Abhishek Parolkar > *Date: *Thu, 29 Mar 2012 16:25:08 +0800 > *To: * > *ReplyTo: * user@hive.apache.org > *Subject: *Postgres JDBC

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-29 Thread Abhishek Parolkar
olating a > primary key. The second insert "fails" and produces non 0 but in > reality all that means is already inserted/ > > On Thu, Mar 29, 2012 at 6:23 AM, Abhishek Parolkar > wrote: > > My situation requires me to run hive query every hour and insert selected > &g

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Abhishek Parolkar
n Fri, Mar 30, 2012 at 9:50 AM, Abhishek Parolkar wrote: > I am definitely getting the no-driver error > http://screencast.com/t/OipV14n9FgF > so its not even at the point of executing statements, my return value from > UDF is 2. > > I can confirm that the postgres driver jar is

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-03-30 Thread Abhishek Parolkar
t; Or in your hive-site.xml as > > hive.aux.jars.path > file:///location/postgresql9jdbc3.jar > ** > > Regards > Bejoy > > -- > *From:* Abhishek Parolkar > *To:* user@hive.apache.org > *Cc:* bejoy...@yahoo.com > *Sent:* Friday, Ma

Re: Postgres JDBC + dboutput UDF to export from Hive to remote Postgres

2012-04-09 Thread Abhishek Parolkar
t the code to see what the return numbers mean for > the UDF. In some cases the return is normal. For example hive maps use > speculative execution and the same insert happens twice violating a > primary key. The second insert "fails" and produces non 0 but in > reality al