[luciddb-users] luciddb flat file import

[Matt B. <mat...@ya...>]

hi guys,

i have a question about importing flat files.
I've got this set up:

file:  /var/db/analytics_olap/current/analytics.csv 


I created a foreign server:

CREATE OR REPLACE SERVER file_load
FOREIGN DATA WRAPPER SYS_FILE_WRAPPER
OPTIONS (
DIRECTORY '/var/db/analytics_olap/current',
FILE_EXTENSION 'csv',
CONTROL_FILE_EXTENSION 'bcp',
FIELD_DELIMITER ',',
LINE_DELIMITER '\n',
QUOTE_CHAR '"',
WITH_HEADER 'YES')

0: jdbc:luciddb:http://localhost> CREATE OR REPLACE SERVER file_load
. . . . . . . . . . . . . . . . > FOREIGN DATA WRAPPER SYS_FILE_WRAPPER
. . . . . . . . . . . . . . . . > OPTIONS (
. . . . . . . . . . . . . . . . > DIRECTORY '/var/db/analytics_olap/current',
. . . . . . . . . . . . . . . . > FILE_EXTENSION 'csv',
. . . . . . . . . . . . . . . . > CONTROL_FILE_EXTENSION 'bcp',
. . . . . . . . . . . . . . . . > FIELD_DELIMITER ',',
. . . . . . . . . . . . . . . . > LINE_DELIMITER '\n',
. . . . . . . . . . . . . . . . > QUOTE_CHAR '"',
. . . . . . . . . . . . . . . . > WITH_HEADER 'YES')
. . . . . . . . . . . . . . . . > java.lang.NullPointerException
No rows affected (0.455 seconds)
0: jdbc:luciddb:http://localhost> Closing: de.simplicit.vjdbc.VirtualConnection



I created a foreign schema and a foreign table:
Create or REPLACE Schema FILE_STAGING;
CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics (
id integer,
load_id integer )
SERVER file_load
OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv');
0: jdbc:luciddb:http://localhost> Create or REPLACE Schema FILE_STAGING;
No rows affected (0.165 seconds)
0: jdbc:luciddb:http://localhost> CREATE OR REPLACE FOREIGN TABLE FILE_STAGING.analytics (
. . . . . . . . . . . . . . . . > id integer,
. . . . . . . . . . . . . . . . > load_id integer )
. . . . . . . . . . . . . . . . > SERVER file_load
. . . . . . . . . . . . . . . . > OPTIONS (filename '/var/db/analytics_olap/current/analytics.csv');
No rows affected (0.444 seconds)


I then try to select from FILE_STAGING.analytics:

select * from "FILE_STAGING"."analytics";
Error: From line 1, column 15 to line 1, column 31: Table 'FILE_STAGING'.'analytics' not found (state=,code=0)

anything i'm missing?

version of luciddb is 0.9.3

thanks,

Matt