SQL LOAD DATA ISSUES
Hello Community,
I'm trying to load a file by execute this LOAD DATA SQL command in both studio and SQL-SMP I got the below error.
///sample executed queriesClassMethod ExecutedQueries()
{
/// executed queries - 1
LOAD DATA FROM FILE 'C:\\FHIRFILE\mycont.csv' COLUMNS ( C_COUNTRY VARCHAR ( 40 ) , C_CODE VARCHAR ( 20 ) ) INTO SAMPLE . COUNTRIES ( COUNTRY , CODE ) VALUES ( C_COUNTRY , C_CODE )
/// executed queries - 2
LOAD DATA FROM FILE 'C:\FHIRFILE\mycont.csv' INTO SAMPLE . COUNTRIES ( COUNTRY , CODE )
}sample data.png)
.png)
$ZV: IRIS for Windows (x86-64) 2024.1 (Build 263) Wed Mar 13 2024 16:01:00 EDT
Discussion (4)2
Comments
In order to use LOAD DATA you need to check that the Java external language gateway is properly configured and working.
Thank you @Enrico Parisi
I enabled the %JavaServer in external language server and it's working now. Documentation
LOAD DATA requires activation of JavaGateway.
>> active in docker community version by default
Thanks @Robert
It's working after enabled the %JavaServer in external language.