[
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)