SAP HANA SQL Dates Aggregation

Availability for the Always-On Enterprise

SAP HANA SQL Dates Aggregation

Veeam Logoby soujanya23. » Mon Aug 14, 2017 6:28 am

I've an trouble with a query i've written for sap hana.

There is basically tables.

First table is a dates desk which incorporates dates for every unmarried day in a calendar. 2nd desk is a consequences table containing a customer reference range and for each consumer reference range a start date and give up date. on this client ref table, i have approximately four million statistics. So essentially within the internal part of the query i'd be getting 4 million records for each day seeing that 01012011. There need to be a simple manner SAP HANA Admin of aggregating the consequences. i have attempted an internal pick out query but it looks as if hana is having performance issues.

i have written the code like this, however this is not most useful.
soujanya23.
Lurker
 
Posts: 1
Liked: never
Joined: Thu Jun 08, 2017 10:28 am
Full Name: Soujanya Naganuri

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: billy.tsang, Bing [Bot], robbysmith and 1 guest