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

Last updated on MAY 05, 2016

Applies to:

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

Goal

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.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms