[ 
https://issues.apache.org/jira/browse/DERBY-6937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16036043#comment-16036043
 ] 

Harshvardhan Gupta commented on DERBY-6937:
-------------------------------------------

Hi Bryan,

I modified the derby code to check for NULL string during the file reading 
logic and ended up creating a variant of SYSCS_IMPORT_TABLE with minimal 
changes, yes there are a lot of ways to get around this problem, I found this 
approach quicker and cleaner in my current environment.

Specifically in ImportReadData.java, I checked the parsed column value in 
readNextDelimitedRow procedure and set it null if it matched the string "NULL".

I agree that there are known workarounds for this problem and it is not the 
focus of our project, let our documentation help someone in future trying to 
set up the environment for analyzing Derby's optimizer.

> Load the IMDB data set in Derby, obtain and adapt Join order Benchmark 
> queries for use in derby 
> ------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6937
>                 URL: https://issues.apache.org/jira/browse/DERBY-6937
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Harshvardhan Gupta
>            Assignee: Harshvardhan Gupta
>            Priority: Minor
>         Attachments: schema_derby.sql
>
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to