Hi Team,
My requirement is to run white source scan on my TEST product for my PR Build and need to run white source scan on actual product for MASTER builds.
in config.yml i have added details for main product but based on my branch (PR/Master) ...
Hi Team,
Can we combine Mutiple select queries separated with semi column and can run in Hana?
Example:
select 'ID' from "TableA" where NAME='TEST_USER';select 'ID' from "TableB" where JOB='Developer';
when we execute above query, we get bel...
We need to calculate the disk size of our Hana DB which includes all table types (ROW, COLUMN and COLLECTION). We used below query to achieve this.
select sum((disk_size)/1024/1024/1024) from m_table_persistence_statistics;
But this is not giving...
Hi Team,
SELECT RECORD_COUNT FROM M_TABLES WHERE TABLE_TYPE = 'COLLECTION';
This always gives NULL.
we have many collection tables in a schema , where we store json objects in collection tables. we need to find the count of all json objects sto...
Thanks for the suggestion. It worked. I mean,If I remove whitesourceProductToken and whitesourceProductname entirely from config.yaml, then passed parameters from jenkins is taking in to considerationa and runs scan on the passed product.
Hi Markus,We need to calculate the disk size of our Hana DB which includes all table types (ROW, COLUMN and COLLECTION). We used below query to achieve this.select sum((disk_size)/1024/1024/1024) from m_table_persistence_statistics;As per the documen...
Hi Markus,We need to calculate the disk size of our Hana DB which includes all table types (ROW, COLUMN and COLLECTION). We used below query to achieve this.select sum((disk_size)/1024/1024/1024) from m_table_persistence_statistics;As per the documen...
How can the collection is loaded into memory by default? As I mentioned we have many collection tables in a schema, so do we need to load collection explicitly whenever we fire a query?and what is the impact of performance on DB if load/unload a coll...
