My Oracle Support Banner

Using Oracle Big Data SQL with Long Strings (Doc ID 2134249.1)

Last updated on OCTOBER 18, 2023

Applies to:

Oracle Big Data SQL - Version 1.0 to 3.0 [Release 1.0 to 3.0]
Linux x86-64


Queries suffering from errors or poor performance on text or character data need to consider the following:

Big Data SQL supports Smart Scan for character types of VARCHAR2 only, with a maximum length of 4000. CLOB types cannot be offloaded. Additionally, Hive tables or HDFS data with String types which exceed 4000 characters will either cause errors or truncation, depending on the access parameters specified on the RDBMS-side external table.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.