Question Why does the following error occur in Scripts and what does it mean: '[p]query function: number of open resultsets exceeds 250" caught in script' Answer The error message : '[p]query function: number of open resultsets exceeds 250" caught in...

Background This article will explain about the details on encryption at Exasol Database. It gives you answers for questions like : Is data transfer through client connection encrypted by default or not? How to check encryption is enabled in database?...

Background Filter on DOUBLE columns returns unexpected results. The DOUBLE values you see in EXAplus may differ from the actual database values due to the JDBC double handling and rendering. Explanation As the DOUBLE data type is only an approximativ...

Background Below is an UDF script in R that executes a scoring model inside EXASOL. While example is using the flights dataset from R and applying a randomForest model, it may be used as a template for R models. It has already proven in a real case w...

Background Hadoop ETL UDFs are the main way to load data from Hadoop into EXASOL (HCatalog tables on HDFS). In order to deploy the ETL UDFs, you need to set up the connectivity between EXASOL and Hadoop. This SOL describes the network requirements to...