Inconsistent datatype: lob type comparision in sap hana
I wanted to see the xml files of information views that are stored in cdata column of _SYS_REPO.ACTIVE_OBJECT in SAP HANA.
But unfortunately, when i'm trying to filter cdata empty values, its throwing the below error:
"Inconsistent datatype: lob type comparison.
Query used to filter and view CDATA column are:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata is not null"
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata !=""
sap hana cdata
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
add a comment |
I wanted to see the xml files of information views that are stored in cdata column of _SYS_REPO.ACTIVE_OBJECT in SAP HANA.
But unfortunately, when i'm trying to filter cdata empty values, its throwing the below error:
"Inconsistent datatype: lob type comparison.
Query used to filter and view CDATA column are:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata is not null"
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata !=""
sap hana cdata
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
add a comment |
I wanted to see the xml files of information views that are stored in cdata column of _SYS_REPO.ACTIVE_OBJECT in SAP HANA.
But unfortunately, when i'm trying to filter cdata empty values, its throwing the below error:
"Inconsistent datatype: lob type comparison.
Query used to filter and view CDATA column are:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata is not null"
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata !=""
sap hana cdata
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
I wanted to see the xml files of information views that are stored in cdata column of _SYS_REPO.ACTIVE_OBJECT in SAP HANA.
But unfortunately, when i'm trying to filter cdata empty values, its throwing the below error:
"Inconsistent datatype: lob type comparison.
Query used to filter and view CDATA column are:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata is not null"
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata !=""
sap hana cdata
sap hana cdata
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
asked Jan 3 at 6:52
Modem Rakesh goudModem Rakesh goud
19615
19615
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Looks like we cant use comparison operations with lob data type in sap HANA. However, we can use LIKE operator with lob datatypes.
Working query is:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata not like ''
and it returns the non empty records.
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54017582%2finconsistent-datatype-lob-type-comparision-in-sap-hana%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Looks like we cant use comparison operations with lob data type in sap HANA. However, we can use LIKE operator with lob datatypes.
Working query is:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata not like ''
and it returns the non empty records.
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
add a comment |
Looks like we cant use comparison operations with lob data type in sap HANA. However, we can use LIKE operator with lob datatypes.
Working query is:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata not like ''
and it returns the non empty records.
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
add a comment |
Looks like we cant use comparison operations with lob data type in sap HANA. However, we can use LIKE operator with lob datatypes.
Working query is:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata not like ''
and it returns the non empty records.
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
Looks like we cant use comparison operations with lob data type in sap HANA. However, we can use LIKE operator with lob datatypes.
Working query is:
SELECT top 10 CDATA FROM _SYS_REPO.ACTIVE_OBJECT where cdata not like ''
and it returns the non empty records.
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
answered Jan 4 at 5:38
Modem Rakesh goudModem Rakesh goud
19615
19615
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54017582%2finconsistent-datatype-lob-type-comparision-in-sap-hana%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
