0

In monetdb I created a table:

create table extractedcatalog(id int, ra double, decl double, x double, y double, z double);

ra,decl are all inserted into tables already, now I want to calculate x,y,z from ra,decl columns. In sql I executed like this: 

update extractedcatalog set x = (cos(radians(decl))*cos(radians(ra)));

but i got response:

connection terminated

Is there any problem with my sql query?

Thanks very much!

Nadeem_MK
  • 7,533
  • 7
  • 50
  • 61
user2706760
  • 3
  • 2
  • 2
    most likely your table is huge. When you execute your query, the database engine creates a big transaction log. The update statement takes time longer then the query timeout set in your system. Try increasing the timeout – cha Nov 20 '13 at 05:11
  • the query seems correct to me !! try increasing query timeout as said above – vhadalgi Nov 20 '13 at 05:13

1 Answers1

0

Please indicate your platform and MonetDB version. A Connection Termination message indicates a loss of contact between your client and server. You may look into the Merovingian log file for further clues on the underlying cause.

mkersten
  • 694
  • 3
  • 7