User Activity

Background Wouldn't it be great if we could execute a query in Exasol that reads your SQL Server database and presents the data as if it resided in Exasol? The SQLServer Virtual Schema provides an abstraction layer that makes an external Microsoft SQ...
Table of Contents BackgroundPrerequisitesHow to set up a Virtual Schema for SQL ServerStep 1Step 2Step 3Step 4.Step 5.Step 6.Step 7.Step 8.Step 9.Step 10.Step 11.Step 12.Step 13.Additional References Scope The error we are addressing is connection lo...
Question Knowing that JOINS on VARCHAR of various sizes can create an expression index, what about using datatype DECIMAL? Answer Before we go into detail, a few things to keep in mind: Joins between columns of the same datatype will build an index t...
Problem JSON data that is stored in EXASOL tables can be accessed through UDFs. JSON documents can be accessed through path expressions. To understand what path expressions are, let us have a look at the following JSON document: { "name": "Bob", "age...
Background Cause and Effect: Since EXASolution transaction isolation level is SERIALIZABLE and newly created transactions are automatically scheduled after finished transactions, it is possible that WAIT FOR COMMITS occur for pure read transactions (...