Availability for the Always-On Enterprise
Post Reply
soujanya23.
Lurker
Posts: 1
Liked: never
Joined: Jun 08, 2017 10:28 am
Full Name: Soujanya Naganuri
Contact:

SAP HANA SQL Dates Aggregation

Post by soujanya23. » 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.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 52 guests