Sorry, the HQL that I gave you was incorrect. The LOAD DATA INFILE statement should read "into table urls" no "into urls". That should solve the problem.
- Doug On Tue, Sep 24, 2013 at 4:29 AM, Mehmet Ali Cetinkaya < [email protected]> wrote: > Hello Doug, > > I tried the command on my master machine but i got hql parse error. > > namespace: crawler > table: result > master host: ht120 > replica host: ht121 > > my command; > > echo "use crawler; select * from urls DISPLAY_TIMESTAMPS;" > | /opt/hypertable/current/bin/ht shell --batch > | /opt/hypertable/current/bin/ht shell --batch -e 'load data infile "-" > into urls;' --Hypertable.Master.Host <remote-master-host> > --Hypertable.Master.Port 38050 --Hyperspace.Replica.Host > <remote-master-host> --Hyperspace.Replica.Port 38040 > > error; > > Error: Hypertable::Exception: parse error at: load data infile "file" > into urls (load data infile "-" into urls) - HYPERTABLE HQL parse error > at void Hypertable::HqlInterpreter::execute(const Hypertable::String&, > Hypertable::HqlInterpreter::Callback&) > (/root/src/hypertable/src/cc/Hypertable/Lib/HqlInterpreter.cc:1014) > - HYPERTABLE HQL parse error > > > What is your suggestion? > > Regards, > > mali > > > > *From:* Doug > > I think you can do something along the lines of: > > echo "use <namespace>; select * from <table> DISPLAY_TIMESTAMPS;" | > /opt/hypertable/current/bin/**ht shell --batch | > /opt/hypertable/current/bin/**ht shell --batch -e 'load data infile "-" > into <table>;' --Hypertable.Master.**Host <remote-master-host> > --Hypertable.Master.Port 38050 --Hyperspace.Replica.Host > <remote-master-host> --Hyperspace.Replica.Port 38040 > > Where <namespace> is be replaced with the namespace that contains your > table and <table> is replaced with your table name, and > <remote-master-host> is replaced with the hostname of the master of the > new cluster you would like to populate. > > - Doug > > ------------------------------ > *From:* Mehmet Ali Cetinkaya <[email protected]> > *To:* "[email protected]" <[email protected]> > *Sent:* Wednesday, September 11, 2013 11:21 AM > *Subject:* Copy All Cluster > > Hi, > > We have 1 master + 7 datanode cluster. And we want to take a mirror of all > hypertable datas. Because, we need 2 different test cluster but same datas > . > > what's the best and easy solution? > > Best regards, > mali > > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/hypertable-dev. > For more options, visit https://groups.google.com/groups/opt_out. > -- Doug Judd CEO, Hypertable Inc. -- You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/hypertable-dev. For more options, visit https://groups.google.com/groups/opt_out.
