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
1 answer

Finding Products Purchased By a customer which he hasn't already done

I have two Tables , One Has Products Purchased by each customer and the Other has the Products Purchased by Customers in the same bracket. I need the Products not purchased by the customer similar to him. Table 1 - Products Purchased |Customer_ID |…
Sowmiya Raja Radhakrishnan
  • 41
  • 6
0
votes
2 answers

how to find maximum of sum of number using if else in procedure in sap hana sql

I want to list out the product which has highest sales amount on date wise. note: highest sales amount in the sense max(sum(sales_amnt)... by using if or case In the procedure in sap hana SQL.... I did this by using with the clause :…
KABIL ARASAN
  • 31
  • 1
  • 4
  • 12
0
votes
3 answers

Merge text in a single column

I have a table, sample records are shown below - Name ID C.NO Text ---- ---- ---- ---- ABC A 1 first ABC A 2 xyz ABC A 3 AMD ZSD B 1 hoho ZSD B …
subbu
  • 1
0
votes
1 answer

GeoMap data as per OData API- SAPUI5

I could successfully load location data (lat,lon) at my Dashboard UI in tabular form using Odata API. Now I need to display them in a Map. I'm referring this as sample. Here is images of my dashboard table . Now from my table, I only need to…
daisy
  • 11
  • 4
0
votes
1 answer

Retrieving erring procedure name , error state , severity and line number in HANA

I have a stored procedure written in T-SQL. I am trying to write equivalent procedure in HANA. I am facing some roadblocks, which are : I am not able to find equivalent of ERROR_STATE(), ERROR_SEVERITY(), ERROR_PROCEDURE(), ERROR_LINE() functions…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
0 answers

Data Type Mismatch during using SSIS to import data to HANA

I am trying to import data from SQL Server to SAP HANA using SSIS package. I am facing the following hurdle : An input source column has data type time(0) Corresponding column in HANA has data type time, which is stored as 'secondtime' in column…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
0 answers

PostgreSQL ODBC “Data source name not found, and no default driver specified”

I am trying to connect my HANA Server (SLES) with a Greenplum cluster. In my HANA server I have installed the last version of PostgreSQL and PostgreSQL ODBC. In "/usr/local/lib/" path I have the following files: -rwxr-xr-x 1 root root 1056 May 8…
Joan Sánchez Escudero
  • 9
  • 6
0
votes
1 answer

Use INT vs. DATE in where clause

I have two tables in a data warehouse: balances and dates. Balances has the following structure: Surrogate Key Date | Date | Account | Balance 1 | 2017-02-01 | 100 | 1234 1 | 2017-02-01 | 200 | 5151 2 …
ps0604
  • 1,227
  • 23
  • 133
  • 330
0
votes
1 answer

Git Clone timeout error in SAP HANA XS Advanced to SAP IDE

I would like to clone project from github to my SAP IDE and I am getting error. Clone request failed Request failed: Gateway Timeout URI: /che/project/workspaceoiqcdmunycarr4ky/import/tinyworld-1?force=true I add in…
Houssem
  • 23
  • 5
0
votes
1 answer

HANA Dependancy

How to find the View Dependency ..For ex i created one view A(Using Table1) and used the View A in View B along with Table2.. Is there a way to find the list of the views used in any View .. For Ex: If i pass View B then i should get View A…
SQL3026
  • 31
  • 3
  • 9
0
votes
1 answer

SAP HANA SQL in calculated column

What are the exact possibilities for Calculated Columns in SAP HANA? I have often trouble building calculated columns - even though using SQL (not column engine) So I have to use concat(col1, col2) instead of col1 || col2 Now I want to do: the…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

Using Large Integer and decimal data types in SAP HANA

I came across the following article https://blogs.saphana.com/2013/04/07/best-practices-for-sap-hana-data-loads/ and was wondering why it is a good practice not to use large integer and decimal types as data types for columns in HANA, the reason…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
1 answer

SAP Hana: Maximum number of row store containers (1835008) exceeded

I am using SAP Hana as my datastore. I caught an exception in my Java code, as follows: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [132]: transaction rolled back due to unavailable resource: search table error: "TN_LIVE"."XXX":…
Prakhar Mishra
  • 1,586
  • 4
  • 28
  • 52
0
votes
1 answer

HANA xsodata create using procedure

Trying to create xsodata via dbprocedure "X"."SHOPLIST/Header" as "Header" navigates ("ToItem" as "ItemRef") create using "X"."SHOPLIST.shoplist::create"; it says Syntax error at line: 3, column: 15. create using "SHOPLIST.shoplist::create"; it…
Kengur
  • 19
  • 4
0
votes
1 answer

Hana Studio: How to execute file1.sql out of master.sql file?

I am completely new to HANA DB as we just start to migrate our smaller SAP Netweaver java Applications to HANA from Oracle I am currently working on finding out what to consider, playing around on sandbox level with try&error running the scripts,…
Gian-Marco
  • 23
  • 7
1 2 3
…
99
100