![]() SAP Sybase Adaptive Service Enterprise: version 15.7 ESD#4.Intel Distribution for Apache Hadoop: version 2.3 (This includes Apache Hadoop version 1.0.3 and Apache Hive 0.9.0.).SAP Note 1868702: Information about installing the drivers that SAP HANA smart data access supports SAP Note 1868209: Additional information about SPS06 and smart data access UPDATE (Dec 04 2013): As of SPS07 Hortonworks HDP1.3 (When’s HDP 2.0 coming?) appears to have been added to the official list, and remote caching of HADOOP Sources has been added, which should hopefully speed queries up for those tables in HADOOP that aren’t changing frequently. UPDATE (Jan 29 2014): SAP HANA Academy now has a great collection of videos using Smart Data Access. SDA: HADOOP - Configuring ODBC drivers | SAP HANA #EXPOSURE JAVA 2013 APCS EDITION TEXTLAB 08 UPDATE# ![]() SDA: HADOOP - using the remote HADOOP data source | SAP HANA #EXPOSURE JAVA 2013 APCS EDITION TEXTLAB 08 DRIVERS# Using Smart Data Access (SDA) with HADOOP seems to me a great idea for balancing the strengths of both tools. Unfortunately for real-time responsiveness HIVE SQL currently isn’t the most optimal tool in HADOOP. Cloudera’s Impala, Hortonworks Stinger initiative and MapR’s Drill are all trying to address real-time reporting. ![]() I’ve only tested Impala so far, but I’ve noticed speeds of 10 to 100 times improvement over standard HIVE SQL queries. With that in mind I thought it would be interesting to test them both in HANA using SDA. Unfortunately I’m using Cloudera’s open-source Apache Hadoop distribution (CDH), which isn’t on SAP’s approved list yet. However since SDA uses ODBC I’ve managed to get it working using a third party ODBC driver from Progress|DataDirect. #EXPOSURE JAVA 2013 APCS EDITION TEXTLAB 08 DRIVER# ![]() NOTE: Since CDH is not currently on this list I’m sure SAP will NOT recommend you using this in a production environment. If you do though get it working in a sandbox environment why not help by adding your voice for it be certified and added to the ‘official’ list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |