Hi @Michael Kay , in addition to what @Candido Dessanti suggested, if you don't need to group by or join on the string (just project or filter on it), you might try making it `Encoding None`, i.e. non-dictionary encoded.
Hi @Michael Kay , The max length of a string is 32767 whatever the encoding you are using, since 3.2.0 release as you can read here https://www.omnisci.com/docs/latest/7_0_release.html#id84 If you try to inject a longer string, an error occurs as ...
Hi there I am getting the error TApplicationException : String too long for dictionary encoding. I have encoded all string variables as "text encoding dict(32)" when building a create table statement. What should I use as the format for my long ...
Hi @Sumit Srivastava as @dwayneberry said there isn't a built-in command to get the size of table and dictionary, but you can try the shell script in attach the parameters you have to provide are the name of the database, the name of the ...