my video https://youtu.be/zx6WoApljBI
my story https://community.intersystems.com/post/45-years-intersystems-1978-2023
Thanks @Raj Singh great input !
I recently struggled with LOAD DATA and finally dropped it in favor
of an old-fashioned COS import for 2 reasons:
- installation of Java was a prerequisite (might be mentioned somewhere, not identified) not a default in community containers
- quality of data was POOR to express it politely e.g:
- column expected to be DOUBLE >> content was
- number
- $ number
- some text
- NULL
- column expected to be DOUBLE >> content was
- date with any sick non -SQL format
- just empty lines by wild running \n
so some exception handling after validation would have been a great feature in my case
to filter out sick records.
The sick CSV is available on GitHub
By SQL priniciple:
any straight name is meant to be a COLUMN of the actual table. eg. Embeddings
but an external HostVariable is designated by an initial : (colon) e.g. : new_embedding_str or :params
This seems to be the deeper cause your problem
in addition I'd suggest to add print(new_embedding_str) to verify its format. (one of my problems.
Furthermore, take a closer look to this example:
iris-vector-search/blob/main/demo/sql_demo.ipynb
PLEASE!
if you have a different question then PLEASE don't change the original content
this breaks the total information flow.
Existing replies will look like nonsense!