Re: hive load data from remote system

2014-03-03 Thread Jone Lura
Hi Vishnu, I have a similar scenario, and I came over the webhdfs project that is a REST service interface to the Hadoop File system. http://hadoop.apache.org/docs/r1.2.1/webhdfs.html Im not sure if this makes it simpler than using FTP, but it is an alternative which may be considered. Best r

Exception

2014-02-28 Thread Jone Lura
Hi all, I am trying to understand why I receive the following exception; java.sql.SQLException: Error while processing statement: FAILED: SemanticException Line 1:23 Invalid path ''/Users/jonelura/tmp/dual167616209284665.csv'': No files matching path file:/Users/jonelura/tmp/dual167616277

Re: Hive JDBC + Jetty

2014-02-26 Thread Jone Lura
you have multiple > versions in your classpath. > > Thanks, > --Vaibhav > > > On Fri, Feb 21, 2014 at 5:31 AM, Jone Lura wrote: > Hi, > > I have encountered a problem when I try to deploy my application on Jetty. > > In my Junit test environment everything works f

Re: Slow performance on queries with aggregation function

2014-02-23 Thread Jone Lura
tasktracker. this is your friend. find your > job and look for failed reducers. That's the starting point anyway, IMHO. > > > > On Fri, Feb 21, 2014 at 11:35 AM, Jone Lura wrote: > Hi, > > I have tried some variations of queries with aggregation function such a

Slow performance on queries with aggregation function

2014-02-21 Thread Jone Lura
Hi, I have tried some variations of queries with aggregation function such as the following query; select max(total) from my_table; and select id, sum(total) from my_table group by id In my junit tests, I only have two rows with data, but the queries are extremely slow. The job detail outp

Hive JDBC + Jetty

2014-02-21 Thread Jone Lura
Hi, I have encountered a problem when I try to deploy my application on Jetty. In my Junit test environment everything works fine, whilst deploying the same application in Jetty I receive the following message; java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration at org

Re: Hive + JDBC issues

2014-02-21 Thread Jone Lura
f it is tab separated or use proper field separator you have. > > You get incorrect results when your table definition does not match with your > actual data > > > On Fri, Feb 21, 2014 at 3:05 PM, Jone Lura wrote: > I used this from the example; > > stmt.execute(&

Re: Hive + JDBC issues

2014-02-21 Thread Jone Lura
create table statement ? > > > On Fri, Feb 21, 2014 at 2:55 PM, Jone Lura wrote: > Hi, > > I am new with Hadoop and Hive, and I am trying to figure out what is = > going wrong. > > In my application I connect successfully to the Hive and I am able to = > load da

Hive + JDBC issues

2014-02-21 Thread Jone Lura
Hi, I am new with Hadoop and Hive, and I am trying to figure out what is = going wrong. In my application I connect successfully to the Hive and I am able to = load data into it. When I try to run a select statement however, things are not as I = expected. The select query returns the correct n