Can't query data from a CSV with empty fields about polypheny-db HOT 8 OPEN

Let me check this out.

from polypheny-db.

The methods in the exception are the symptoms , underlying disease seems to be in the csv loader. Null handling cases might have been missed

from polypheny-db.

Looks like instead of universally setting all null we need to initialize something else or allow null handling

from polypheny-db.

From DBMS perspective null shall be OK, so ig the way injection of null is happening into the database is troubling

from polypheny-db.

Filtering does not work on that too, we currently cannot sort based on such fields

from polypheny-db.

Interestingly this works
SELECT latitude,hoehe FROM public.baeume

from polypheny-db.

The error message you provided is a stack trace that indicates an exception occurred in a software application. Here's a breakdown of the information provided:

• The error occurred at 13:35:56.886.
• The error is of type "ERROR" and is related to executing a query from the console.
• The specific exception is a org.polypheny.db.webui.Crud$QueryExecutionException, which is caused by a java.lang.RuntimeException that, in turn, is caused by a java.lang.NullPointerException.
• The error stack trace shows the sequence of method calls leading to the exception, starting from org.polypheny.db.webui.Crud.executeSqlSelect(Crud.java:3667).

Based on this information, it seems that the error originates from a web-based user interface (UI) component called "Crud" in the Polypheny-DB system. Polypheny-DB is a database management system, and the error occurred while executing a SQL select query. The cause of the exception appears to be a NullPointerException that occurred within the Functions.toFloat method, which is part of the org.polypheny.db.runtime.functions package.

To further investigate and resolve the issue, it would be necessary to analyze the source code of the Polypheny-DB system, particularly the Crud class and the Functions class. Additionally, examining the specific query being executed and the data involved could provide more insights into the cause of the NullPointerException and potential fixes.

from polypheny-db.

try:
# Execute the SQL query from the console
result = executeSqlSelect(query)
# Process the result or perform further actions
processResult(result)
except QueryExecutionException as e:
# Handle the query execution exception
handleQueryExecutionException(e)

def executeSqlSelect(query):
try:
# Perform necessary operations to execute the SQL select query
# ...
# Return the result
return queryResult
except RuntimeException as e:
# Log the error or perform error handling
logError(e)
# Raise the exception to the calling code
raise QueryExecutionException("Error executing SQL select query")

def processResult(result):
# Process the query result
# ...
pass

def handleQueryExecutionException(exception):
# Log the exception details or perform error handling
logError(exception)
# Handle the exception as required
# ...

def logError(error):
# Log the error details to a log file or console
# ...
pass

from polypheny-db.