You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
An error is reported when the amount of data is too large
It is normal to test 200 million data of the same code for dozens of times, and 500 million data will report an error
The code is as follows:
public static void addDataToTable() {
try
{
There is no problem when this code generates 200 million pieces of data, but there is a problem when it increases to 500 million
java.sql.SQLException: Catalog Error: Table with name test does not exist!
LINE 1: SELECT * FROM test
^
at org.duckdb.DuckDBNative.duckdb_jdbc_prepare(Native Method)
at org.duckdb.DuckDBPreparedStatement.prepare(DuckDBPreparedStatement.java:75)
at org.duckdb.DuckDBPreparedStatement.executeQuery(DuckDBPreparedStatement.java:129)
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
An error is reported when the amount of data is too large
It is normal to test 200 million data of the same code for dozens of times, and 500 million data will report an error
The code is as follows:
public static void addDataToTable() {
try
{
The query code is as follows:
public static void main(String[] args) {
System.out.println("++++++++++++++");
String sql1="SELECT * FROM test";
queryTest(sql1);
}
public static int queryTest(String sql) {
try
{
Properties ro_prop = new Properties();
ro_prop.setProperty("duckdb.read_only", "false");
DuckDBConnection conn = (DuckDBConnection) DriverManager.getConnection("jdbc:duckdb:C:\test\duckdb\test.db");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
rs.close();
stmt.close();
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
return count;
}
There is no problem when this code generates 200 million pieces of data, but there is a problem when it increases to 500 million
java.sql.SQLException: Catalog Error: Table with name test does not exist!
LINE 1: SELECT * FROM test
^
at org.duckdb.DuckDBNative.duckdb_jdbc_prepare(Native Method)
at org.duckdb.DuckDBPreparedStatement.prepare(DuckDBPreparedStatement.java:75)
at org.duckdb.DuckDBPreparedStatement.executeQuery(DuckDBPreparedStatement.java:129)
What caused this problem?
Beta Was this translation helpful? Give feedback.
All reactions