Best approach for data mashup... Import external Data from MySQL to a Hive table or use Custom Map using JDBC?

2010-11-16 Thread Marcello de Sales
Hello all, I'm using Hive to do mashups of data that is currently on HDFS and data is that is on a MySQL database... I'm considering this scenario instead of bringing the data from MySQL to HDFS because it is a matter verifying the relating data from the query to the data in the external data stor

Re: Question table visibility in hive

2010-11-13 Thread Marcello de Sales
Based on the default hive configuration, different directories called metastore_db can be created in different locations... If you are prototyping and trying hive with your peers, it is even worse... Someone creates a table, others don't see it due to the fact that users are not using the same meta

Re: How to add jar to Hive "globally"?

2010-11-11 Thread Marcello de Sales
I like the approach to have the properties in the hive-site.xml, as I have it under version control... Thanks for the suggestions... Marcello de Sales On Thu, Nov 11, 2010 at 8:45 PM, Edward Capriolo wrote: > On Thu, Nov 11, 2010 at 11:42 PM, Shrijeet Paliwal > wrote: > > One other