go to post Robert Cemper · Apr 2 there is an example in OEX https://openexchange.intersystems.com/package/db-migration-using-SQLgateway It's for PostgreSQL but the difference is only the specific jdbc used
go to post Robert Cemper · Apr 1 Congratulations to all the winners!It was a great event and highly useful to follow.
go to post Robert Cemper · Mar 28 PLEASE!if you have a different question then PLEASE don't change the original contentthis breaks the total information flow.Existing replies will look like nonsense!
go to post Robert Cemper · Mar 27 Thanks @Raj Singh great input !I recently struggled with LOAD DATA and finally dropped it in favorof 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 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 caseto filter out sick records. The sick CSV is available on GitHub
go to post Robert Cemper · Mar 27 By SQL priniciple: any straight name is meant to be a COLUMN of the actual table. eg. Embeddingsbut 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
go to post Robert Cemper · Mar 27 Sounds promising:in my COS example, I had to use pure String parameters like "0.54456,0.6987646,0.I123" happened by accident, more for reading and debugging
go to post Robert Cemper · Mar 26 I use a similar setup in my example in OEX ,Especially with TO_VECTOR() I ran into problems if I didn't add the explicittype and size of the vector. e.g. TO_VECTOR("..........",,DOUBLE,384)as model all-MiniLM-L6-v2 produces exactly that type and size:Don't ask for why. I just used the proposed example
go to post Robert Cemper · Mar 26 - Thank you @Andrew Wardly:Your observation is pretty correct. It derives from a late Latin dialect spokenaround Locarno (today Switzerland) around 1600. Eventually starting with a very sharp S.So the mental link to "Semper Fidelis" is pretty close and matches well.
go to post Robert Cemper · Mar 22 eventually better to check for longer lists USER>s x=$lfs("Purple,Black,Yellow,Pink") USER>s y=$lfs("Red,Green,Orange,Yellow") USER>f z="y","x" f i=1:1:$ll(@z) i $i(dif($li(@z,i))) USER>zw dif dif("Black")=1 dif("Green")=1 dif("Orange")=1 dif("Pink")=1 dif("Purple")=1 dif("Red")=1 dif("Yellow")=2 looping with $o() over dif() allows programmatic check
go to post Robert Cemper · Mar 22 set x="1,4,6,8,9,12" while x>0 {write +x,! set x=$piece(x,",",2,*) } x only !
go to post Robert Cemper · Mar 21 set X="1,4,6,8,9,12" for i=1:1:$L(X,",") set Y=$p(X,",",i) write Y,!
go to post Robert Cemper · Mar 21 I just realized that $vector() is a left+right function similar to $li() set $vector(target,...) = .... to set set vec = $vector(...) to get
go to post Robert Cemper · Mar 21 Thanks. I just looked for TO_VECTOR but failed at that timehttps://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...covers my needs.
go to post Robert Cemper · Mar 21 Thanks.I was looking for this but couldn't detect.https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=RCOS_fvector It is not on https://docs.intersystems.com/iris20241/csp/docbookbut on https://docs.intersystems.com/irislatest/csp/docbook which is not covered by Doc Search
go to post Robert Cemper · Mar 21 experimenting with class %Library.Vector I found an unattractive way: ;; compose JSON array >> v USER>zw v v=[($double(.5)),($double(1.5)),($double(2.2000000000000001776))] ; <DYNAMIC ARRAY> USER>set vec=##class(%Vector).OdbcToLogical(v) USER>zw vec vec={"type":"double", "count":3, "length":3, "vector":[$double(.5),$double(1.5),$double(2.2000000000000001776)]} ; <VECTOR> Applying OdbcToLogical was really shocking
go to post Robert Cemper · Mar 21 Indeed:I was unable to locate an official docu on new SQL function TO_VECTOR()Similarly, I found no documentation on how to set a VECTOR Datetype on pure object levele.g. obj.vectorproperty = ?????? or obj.vectorproperty.set(?????)I tried a bit with DisplayToLogical but gave up in the end
go to post Robert Cemper · Mar 21 Routine names starting with %Z or %z go to namespace %SYS automatically:Though by mapping it to namespace %ALL any routine can be available in any namespace
go to post Robert Cemper · Mar 20 Hi al!,Just returning from some private troubleshooting I'm deeply moved and thankful for this feedback.It's once more a motivation to continue my activities.Sometimes I'm insisting on small pieces that may bypass general attention.Though servicing customers - and I understand you all as my customers -requires to take care also of the small and often annoying pieces. Special big THANKS to the brilliant team behind the DC+OEX+GM facility.YOU ARE GREAT. 💐🌷🌺🌸💮🌼🌻
go to post Robert Cemper · Mar 16 CLOSING / SOLVED I bought a new box with an N100 processor I got a Win11 Pro included for free Installed a new Docker Desktop version (48.0) And all the necessary infrastructure around 5 hrs later the fresh IRIS 2014.1 runs inside and outside Docker ¡ with some 100$ invested at the right time you can solve a lot of problems !
