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.
