HANA_SPS07_NEW_SDA

New or Improved smart data access Features
Support for new Remote Sources such as Oracle and MS SQL Extended DML to Insert/Update/Delete on Virtual Tables Calc View Support for Virtual Tables Deliver Generic Adapter framework to extend additional Remote Sources ‘Remote Caching’ for Hadoop sources Support for CLOB & BLOB data types hdbsdautil – utility to debug Remote Source configuration
Syntax
Select * from hive_activity_log where incident_type = ‘ERROR’ and plant =’001’ with hint (USE_REMOTE_CACHE)
© 2013 SAP AG. All rights reserved.
Public
• When creating a calculation view, it will be possible to add virtual tables as data sources. • Virtual tables can also be referenced by the calculation scenarios. • The support for adding virtual tables in the calculation view can also be done from SAP HANA Studio. • Optimizations such as push down of filters is also supported is these Calc scenarios.
© 2013 SAP AG. All rights reserved.
Public
10
Thank you
Contact information
Balaji Krishna SAP HANA Product Management AskSAPHANA@ To get the best overview of what’s new in SAP HANA SPS 07, read this blog.
© 2013 SAP AG. All rights reserved.
Public
9
Disclaimer
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agreement with SAP. SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAP’s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.
What´s New? SAP HANA SPS 07
SAP HANA smart data accePS 07)
SAP HANA Product Management November, 2013
Scope of Delta from SAP HANA SPS 06 to SPS 07
When SAP HANA dispatches a federated query to HIVE, it involves series of ‘map’ and ‘reduce’ job execution. This could take few minutes to hours to complete a query depending on the data size in Hadoop and the current cluster capacity. In most cases, the data in Hadoop cluster is not frequently updated and successive execution of map/reduce jobs might result in same tuples.
• Sample Properties file entries
CAP_SUBQUERY : true CAP_SUBQUERY_GROUPBY : true CAP_SUBQUERY_SELLIST : true CAP_SUBQUERY_UPDATE : true CAP_ORDERBY : true CAP_ORDERBY_EXPRESSIONS : true CAP_ORDERBY_UNRELATED : true CAP_ORDERBY_UPDATE : true CAP_JOINS : true CAP_JOINS_OUTER : true CAP_JOINS_MIXED : true CAP_GROUPBY : true CAP_GROUPBY_ALL : true
As of SPS 07, HANA allows this result view to be materialized in the remote system thus avoiding the repetitive execution of the same query. This behavior can be controlled by hinting the optimizer to use remote caching.
© 2013 SAP AG. All rights reserved.
Public
8
Configuration Validation Utility - hdbsdautil
• The utility check drivers and dependency files of given data source type. • Can also connect to remote database with given credential information and run query with/without result set display. • Syntax
© 2013 SAP AG. All rights reserved.
Public
2
New and Improved SDA Features
Expand Remote Source systems support
With SAP HANA SPS 07 smart data access will support new data sources such as
hdbsdautil -t <data source type> -S <DSN or string> [-U <username> [-P <password>]] [-Q <SQL>] [-nr] [-info]
• Examples
hdbsdautil -t tdodbc -S "dsn=td_dsn" -U test -P test -info Try to connect to a remote Teradata database with ODBC configuration in property file (e.g. ~/.odbc.ini) With username and password specified Dump ODBC information to console
Limitations: no support of aggregate / group by / order by function push down
© 2013 SAP AG. All rights reserved.
Public
6
Remote caching for Hadoop sources
Oracle 12c Microsoft SQL Server ver11 Hadoop Hortonworks HDP 1.3