Using Oracle Big Data SQL with Long Strings
Last updated on MAY 05, 2016
Applies to:Oracle Big Data SQL - Version 1.0 to 3.0 [Release 1.0 to 3.0]
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms