on 09-18-2019 8:32 AM
Hi All,
I am trying to run a HANA query with multiple inner joins and filter on partition ranges. When I changethe partition range or do a count(*), my query is running fine. But selecting some columns from the joined tables with specific partition key filter (which is in "others" partition), I am getting the below error:
SAP DBTech JDBC: [2048]: column store error: search table error: [23058] exception 70023058: Internal error during join: invalid object state
Can you please help on this issue.
Thanks,
Mathan.
Hi mathanmsd ,
If you are using MDC on a SAP HANA 1.0 database Revisions of SPS12 <= 122.13, this SAP Note 2557786 - SQL Statement Fails With "column store error: search table error" - "Attribute id... would help you.
Then, empty the plan cache of the tenant in which the SQL statement fails should work.
If not, can you provide more details about the version you're using.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.