db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harshvardhan Gupta (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6937) Load the IMDB data set in Derby, obtain and adapt Join order Benchmark queries for use in derby
Date Sat, 03 Jun 2017 18:50:04 GMT

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

Mime
View raw message