Are you running the script from the command line by filename, or pasting it into an interactive grunt session? If you're pasting, it only runs the first STORE statement. Just a guess.
Russell Jurney http://datasyndrome.com On May 9, 2013, at 5:56 PM, Ruslan Al-Fakikh <[email protected]> wrote: > I was just thinking that using Sqoop is a more reliable and robust > solution. I guess it may work in cases where other tools don't. And > probably it can provide some more useful functionality. > > > On Wed, May 8, 2013 at 9:47 PM, Shahab Yunus <[email protected]> wrote: > >> @Peter thanks for the tip. -no_multiquery flag works but I guess it will be >> a performance hit. It is weird because it does not generate any error >> otherwise. In fact success message is explicitly logged even if nothing is >> saved. >> >> @Ruslan, yeah I was thinking of that too but then the thing is that if we >> indeed have to split the processing and first generate multiple HDFS files >> and then use SQOOP to load RDMS, then why not write few more short PIG >> scripts to load those HDFS files in RDMS? >> >> Regards, >> Shahab >> >> >> On Wed, May 8, 2013 at 12:27 PM, Ruslan Al-Fakikh <[email protected] >>> wrote: >> >>> Hi, >>> >>> It is possible to have multiple store statements, but I can't tell why >> you >>> have nothing in the result. >>> I recommend to split the task to the appropriate tools: store everything >> in >>> HDFS and then run Sqoop to upload data to an RDBMS. >>> >>> Ruslan >>> >>> >>> On Wed, May 8, 2013 at 6:11 PM, Shahab Yunus <[email protected]> >>> wrote: >>> >>>> Hello, >>>> >>>> In a Pig script I want to store the results in 2 different MySql tables >>>> (using DBStorage) and a file on HDFS. This means 3 different STORE >>>> statements. Right now when I do that, it does give success message in >> the >>>> logs but saves nothing. What am I missing? Is it even possible? >>>> >>>> I know I can use MultiStorage from PiggBank but I think it i sonly for >> 2 >>>> HDFS files. I want to store in 2 different MySQL tables or a MySQL >> table >>>> and an HDFS file. >>>> >>>> Any recommendations? Thanks. >>>> >>>> Regards, >>>> Shahab >>
