on 11-29-2011 6:43 PM
Dear HANA Gurus,
We have would like to build EDW using HANA base on our source system Oracle and it's supports CLOB and BLOB datatypes
Would you please suggest how do we handle in HANA DB.
Let not say it's oracle specific.
Regards,
Manoj
Thanks Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manoj,
How can you resolve it, I hit the same issue:
Could not execute 'SELECT "OriginalLanguageRef" FROM "SYSTEM"."ErrorReproduce_3" where TO_CLOB('k') = TO_CLOB('k')' in 5 ms 745 µs .
SAP DBTech JDBC: [266] (at 70): inconsistent datatype: lob type comparison: line 3 col 8 (at pos 70)
Thanks
Yanan
Hello,
check SAP HANA SQL Reference Guide for list of data types:
(page 14 - Classification of Data Types)
https://service.sap.com/~sapidb/011000358700000604922011
For this purpose might be useful following data types:
Large Object (LOB) Types
LOB (large objects) data types, CLOB, NCLOB and BLOB, are used to store a large amount of data such as text documents and images. The maximum size of an LOB is 2 GB.
BLOB
The BLOB data type is used to store large binary data.
CLOB
The CLOB data type is used to store large ASCII character data.
NCLOB
The NCLOB data type is used to store a large Unicode character object.
Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thomas,
A quick follow up about lob datatypes. I looked though the documentation for the restrictions of lob datatypes. According to the documentation I should have no issues running a simple select statement that compared lob datatypes using '=', for example
select TO_CLOB('1') from dummy where TO_CLOB('1')=TO_CLOB('1');
However, I get an error
Could not execute 'select TO_CLOB('1') from dummy where TO_CLOB('1')=TO_CLOB('1')' in 3 ms 965 µs .
SAP DBTech JDBC: [266] (at 37): inconsistent datatype: lob type comparison: line 1 col 38 (at pos 37)
According to the documentation : LOB columns cannot appear in WHERE clauses as a predicate except LIKE, CONTAINS, =, or <>.
Am I missing something?
Thanks!
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.