RE: Question about Pig UDF and sqoop export

2011-05-04 Thread Sharma, Akash
Finally figured it out. Flatten did the trick. Had to call flatten on the tuple returned by the UDF as shown below. B = FOREACH A GENERATE FLATTEN(PackageName.MyMethod()); Hope someone out there can make use of this behavior. Thanks -Akash -Original Message- From: Sharma, Akash

Question about Pig UDF and sqoop export

2011-05-03 Thread Sharma, Akash
New to Pig UDF so requesting help to resolve the issue Created a Pig UDF to transform an input tuple and generate an transformed tuple. Executed a Store to save the transformed tuple into a file B = FOREACH A GENERATE PackageName.MyMethod(); STORE B into 'output' USING PigStorage(); My question

External Hive Table with sqoop import

2011-04-04 Thread Sharma, Akash
Hi, I am trying to create an external hive table (with data) using the sqoop import from the "--hive-import" command. The requirement is to actually create an "External" hive table instead of it being part of hive metastore. I wanted to know if there is a way to accomplish this using

RE: Export to MySQL

2011-03-28 Thread Sharma, Akash
Scoop=Sqoop Thanks -Akash -Original Message- From: Sharma, Akash [mailto:akash.sha...@searshc.com] Sent: Monday, March 28, 2011 9:40 AM To: user@hive.apache.org Subject: Export to MySQL New to Hadoop/Hive/Scoop. Wanted to find out the best option to export data out of HDFS and into a

Export to MySQL

2011-03-28 Thread Sharma, Akash
New to Hadoop/Hive/Scoop. Wanted to find out the best option to export data out of HDFS and into a MYSQL database. I have read about scoop export but also wanted to know if there are other ways as well. Please share any scoop export if handy. Any help in this direction is appreciated. Thanks -Aka