Hello Team,
I've a partitioned table on a column with data-type date.The Explain Plans differ when I change the where condition for a typical hard-coded date and an expressionCase 1 : When I use normal where condition without any expression:
C...
Hello Team,
We've a user with gets de-activated due to too many invalid connection attempts. We need to identify as to who exactly has put in the wrong password for the user in SAP HANA. Is there any view which stores this information ?I've checked...
Hello,
I've a scenario where the queries on Calculation View and Table Functions fail with error General error;258 insufficient privilege.The same queries run absolutely fine when we re-activate the Table functions and Calculation Views.This is a r...
Hello,
I've a requirement where I want to insert/update into a table based on a primary key.
I've one column named RECORD_DATE whose default value I've set to current_timestamp.
Now when I'm getting a new record on the same primary key, I don't...
We need to load Hana Table A in DB1 which is a replica of Hana Table B in DB2.
We need to load Hana Table A parallely when the inserts are being performed on Hana Table B.
The size of table is 500million so SLT replication doesn't seem to be an o...
Change the table function from INVOKER to DEFINER security mode so that SELECT privilege on the object that was permanently dropped/recreated was not required anymore.
Can you try this:select case when floor(130805.75/3600) < 10 then '0' || floor(130805.75/3600) else '' || floor(130805.75/3600)end|| ':'|| case when mod(130805.75,3600) = 0 then '00' when mod(130805.75,3600) > 0 and mod(130805.75,3600) < 600 the...
Hello jbrandeis,Thanks for your comment.As I've mentioned, this issue isn't specific to a particular TF or CV, its a random one and gets resolved when I re-activate the respective TF or CV, without granting any extra permissions.As asked, I've attach...
Thanks, Florian.Exactly, even I tried using the same way and the record date wasn't getting updated.But, not very clear as to why there is such weird behaviour.
