Stack Overflow
Stack Overflow

Questions tagged [hana]

SAP HANA is SAP SE’s implementation of in-memory database technology. Not to be confused with similarly named products and technologies e.g. S/4HANA, Boost.Hana, SAP HANA Vora, or SAP Cloud (SAPcp)

###About

SAP HANA is a development platform and database management system that uses in-memory database technology allowing the processing of massive amounts in real-time.

It integrates a wide range of data processing capabilities (predictive analytics, SQL, Geospatial, graph processing, data stream analytics, data warehousing, machine learning) with enterprise grade data management and with modern application development/deployment tools (cloud foundry style containers).

SAP HANA is the data processing platform SAP uses for all its products, both on-premises and in the cloud. It is the basis for future developments.

A resource streamlined version of SAP HANA on a free license up to 32 GB (including productive scenarios) is available for download and for deployment in cloud PaaS setups like AWS, MS Azure and Google Cloud Platform (HANA Express Edition, see link below).

Available interfaces & Capabilities

  • JDBC
  • ODBC
  • ODBO (OLE DB for OLAP, used for business intelligence)
  • SQLDBC (C++)
  • Python DBAPI
  • MDX
  • REST APIs
  • node.js HDB library
  • SQL and SQL Script
  • Text Analysis and Text Mining
  • Graph Data processing
  • Hadoop and Spark integration
  • node.js, Java and Bring Your Own Language development
  • Geospatial data processing
  • Predictive Analytics
  • Data Streaming

Links

###Related tags

, , , , , , , , , , , , ,

1915 questions
0
votes
4 answers

case when statements in sap hana

I would like to know what can I use to be able to do: If condition1 true then only display condition 1 value else go to condition 2 and display only condition 2 value. I have tried to use case when but this seems to be executing both WHEN…
DazM
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

Join tablevariable in a loop

I'm using SAP HANA and would like to join the output results of a procedure call inside a loop, is there anyway to do this? Something similar to this: But the problem is the duplicate attribute name FOR i IN 1..:nYEARS DO CALL FUTUREREVENUES…
Matthias
  • 461
  • 7
  • 24
0
votes
1 answer

Can HANA incremental backups be scripted?

Can HANA incremental backups be scripted? As per SAP note ‘1642148 - FAQ: SAP HANA Database Backup & Recovery’: “Are incremental and differential backups available? Yes. Starting with HANA SPS 10 incremental and differential data backups are…
Fionn Keane
  • 1
  • 1
0
votes
1 answer

Creating a Column Store Table Type in HANA

I am trying to create a table type which has ARRAY as a column type in SAP HANA. When I use the standard DDL for creating the table type, i.e. CREATE TYPE MYSCHEMA.TABNAME AS TABLE("ObjList" INTEGER ARRAY); I get the following error : Could not…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
2 answers

SAP Spark Controller not caching data

I've got Spark Controller 2.0.0 running on a HDP 2.4.3 with Spark 1.6.2 In the configuration I have these parameters configured: sap.hana.es.enable.cache=true sap.hana.es.cache.max.capacity=500 sap.hana.hadoop.datastore=Hive I've got HANA 1.00.122…
Roman
  • 238
  • 1
  • 14
0
votes
1 answer

how to call a JSView from an XSJS file?

I know I can call other JS files from XSJS by making a .xsjslib file. I would like to be able to call a JSView instead. Is this possible? Note: the reason for me to this is that I can then use the SAPUI5 libraries and make it easier to import…
polaris
  • 339
  • 2
  • 14
  • 33
0
votes
1 answer

Performance for selecting multiple out-params from deterministic SUDF

I am about to test the deterministic flag for SUDFs that return multiple values (follow up question to this). The DETERMINISTIC flag should cache the results for same inputs to improve performance. However, I can't figure out how to do this for…
Jan
  • 59
  • 8
0
votes
1 answer

SQL/SAP HANA SQL DATATYPES

I need to know how can i get an 'E' to appear for each of the columns when the sum of all these columns = 0. I've tried case when <...> then 'E' but i keep getting "SAP DBTech JDBC: [339]: invalid number: not a valid number string 'E'" i figure its…
DazM
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

HANA Left Outer Join syntax

I am trying to build a query in HANA with a left outer join. I am using a (+) sign in the where clause. I do that often in Oracle; but in HANA it is returning a syntax error. Does HANA supports this syntax? select * FROM …
Luis Garcia
  • 1,311
  • 6
  • 19
  • 37
0
votes
1 answer

Time dependent Master data via History tables in SAP HANA

I was looking for the best way to capture historical data in HANA for master data tables without the VALID_TO and VALID_FROM fields. From my understanding, we have 2 options here. Create a custom history table and run a stored procedure that…
Analytics1988
  • 13
  • 8
0
votes
1 answer

Calling a procedure or function in a select statement

I have been banging my head once again on HANA syntax. I have been looking for a method of writing either a function or procedure and calling the function or procedure in a select statement to evaluate a column in a table and alter the column based…
MRUNIVERSE
  • 31
  • 1
  • 6
0
votes
1 answer

sql duration around the reference date

There are a pool of customers in the table customer with some activities and each customer has perfomed a specific activity and it has been marked as an event occured and the date has been selected as reference date. Now the task is to find records…
sveer
  • 427
  • 3
  • 16
0
votes
0 answers

SAPUI5 Web-Application: VizFrame (stacked column) show sum of measures (y-Axis)

Currently, I am working on a web application (html5, sapui5) that visualizes customer data. For now we had a simple model that basically shows you how many items were repaired/sent back unrepaired etc. So, it looks like that in SAP HANA: month -…
Notche
  • 11
  • 4
0
votes
1 answer

SAP HANA: Customer history

I have different tables with customer Id, items bought with a date of purchase. books table consists of customer id, bookNr and date of purchase. shoes table consists of custoemr id, shoeNr and date of purchase. . . we have like for every item a…
sveer
  • 427
  • 3
  • 16
0
votes
2 answers

How to consider a long "integer" as a string in SQL query when useing R to connect HANA?

I am using R package RODBC to connect HANA. One of the columns is like a long integer, but actually used as a string such as 2772161413309, 4239530000000239. SQL takes such data as integers. In R, these numbers are shown in scientific notation like…
Feng Chen
  • 2,139
  • 4
  • 33
  • 62
1 2 3
…
99 100