Re: Recommendations on moving to Hadoop/Hive with Cassandra + RDBMS

2011-08-30 Thread Eric Djatsa
RDBMS. For example, a sample > task that already runs on the system is "once in every hour, get rows from > column family X, aggregate data in columns A, B and C and write back to > column family Y, and enter details of last aggregated row into a table in > mysql" > > Tha

Re: Rename Hive partition

2011-06-02 Thread Eric Djatsa
Hi Jon since a partition appears as a column ( for example with *desc table_name* ) you could try renaming the partition as if it was a column as explained in the wiki : ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment] [FIRST|AFTER column_name] I

Re: An issue with Hive on hadoop cluster

2011-05-24 Thread Eric Djatsa
Hi, I had similar problems when I was setting up my hadoop cluster. The Datanodes where trying to access localhost instead of my namenode. To fix this issue I modified my /etc/hosts file on all my nodes (namenode + datanodes) in such a way that the first line corresponds to the binding hostname>.

java.lang.RuntimeException: java.io.FileNotFoundException: HIVE_PLAN

2011-05-17 Thread Eric Djatsa
Hi, I configured an Hadoop cloud with Hadoop 0.20.2-cdh3u0. I extracted some tables from an Oracle DB with sqoop + OraOOp plugin an distributed the data on my nodes. I am using Hive (hive-0.7.0-cdh3u0 ) to perform some analysis on my data. However I am encountering an issue that I can't figure out