search

LordThread / starschema-bigquery-jdbc

Automatically exported from code.google.com/p/starschema-bigquery-jdbc
0 stars 0 forks source link

Can't use update/insert function #11

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. I installed RazorSQL using bigquery-jdbc to connect with bigquery
2. I execute "select" successfully using RazorSQL
3. When I execute "update/insert" , it fails.

I see the error "ERROR: executeUpdate(string)". Does the driver support update 
data now ?I see the desription "Starschema's high performance Google BigQuery 
JDBC Driver provides methods for querying and updating data in a Google 
BigQuery database. If the driver supports update data, Could you give me an sql 
example?

I use bqjdbc-1.4.jar and is "Windows Server 2008 R2 Datacenter" os.

Thank you very much!

best wishes!
louise

Original issue reported on code.google.com by wanming...@htc.com on 21 Aug 2014 at 4:04

GoogleCodeExporter commented 8 years ago 
Since BQ can't do update - we don't support that. Try append. ; )

Original comment by ad...@starschema.net on 21 Aug 2014 at 10:31

GoogleCodeExporter commented 8 years ago 
Hi,
    Thanks for your response! Could you give me an "append" example If I want to insert data into BigQuery? Because when I run  {{  INSERT INTO mydataset.human VALUES ("aa","bb");  }}, the windows give me a hint " ERROR: executeUpdate(string) ". It seems that it doesn't support the insert operation. 

    Thanks!

Original comment by wanming...@htc.com on 22 Aug 2014 at 3:04

GoogleCodeExporter commented 8 years ago 
add a screenshot of "insert error"

Original comment by wanming...@htc.com on 22 Aug 2014 at 3:06

Attachments: