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
2 answers

SQL Query nvarchar to date

I am working on SAP HANA Studio and have tried to run SQL command that converts an entire column of field, nvarchar, into one of field, date. My dates have format: dd-mon-yyyy (i.e '29-Mar-1997') with field nvarchar(11). I have looked at previous…
Diana Vazquez Romo
  • 152
  • 1
  • 1
  • 11
0
votes
2 answers

SAP Vora: Not able to add Vora table as Virtual table via Smart Data Access in HANA Studio

I'm using a VM with HANA Express 2 SP 01. On a small test cluster I installed the Hortonworks Data Platform 2.6 with Spark 1.6.3, and also added HANA Vora 1.4 and the Spark Controller 2.1. I followed the SAP Vora Installation and Administration…
D. Müller
  • 3,336
  • 4
  • 36
  • 84
0
votes
0 answers

SAP B1 Link AP invoice to PO user

I am trying to generate a query that will return header information for Payment-Hold AP Invoices but also show the username that entered the originating Purchase Order. Some of my invoices do not have a relationship history so I wouldn't expect any…
sarnieken
  • 1
  • 1
0
votes
1 answer

a list into a column sql

I have few items item1 item2 item3 item4.. item10 I would like to have a view in sql where I have them in a column Items ------ item1 item2 item3 item4 .... .... .... item10 any suggestions would be appreciated! the below what i have tried select…
sveer
  • 427
  • 3
  • 16
0
votes
1 answer

query XML file in a sql script

In HANA, I need information on calculation view like cross client or not, commentary on node, cardinality... Those information are in XML file of the calculation view. Is it possible to extract it with a procedure? During my research I found this :…
SAPdev64
  • 1
  • 4
0
votes
1 answer

“first argument“ error when using shinyapps.io, rodbc to show sql query result in web

First of all, I need to use R to get SQL query result from HANA database, which I finish by using RODBC in Rstudio. Second of all, I need to share my code with others, which I use shinyapps.io to finish. However, I need to use shinyapps to show my…
Feng Chen
  • 2,139
  • 4
  • 33
  • 62
0
votes
1 answer

How to append rows to sap hana table type?

Try to find way to add rows to table type that not empty without removing content. CREATE TYPE "TPU"."TYP_ACTION" AS TABLE ("ID" BIGINT CS_FIXED, "NAME" NVARCHAR(255) CS_STRING) declare actions "TPU"."TYP_ACTION"; The only way i found…
adelak
  • 647
  • 4
  • 11
  • 25
0
votes
1 answer

Moving data from MySQL to SAP HANA with python

I'm trying to migrate data from a MySQL DB to HANA utilizing Python. The way we're currently implementing this migration at work is manually but the plan is to run a script everyday to collect data from the prior day (stored in MySQL) and move it to…
Nirav
  • 53
  • 1
  • 1
  • 6
0
votes
1 answer

Hierarchy table, update column for a particular level

So I have a hierarchy table in the following format: Instance | Parent | Serial | Hierarchy Level 1 | 0 | x0 | 1 2 | 0 | x1 | 1 3 | 1 | xy0 | 2 4 | 1 | xy1 | …
Alexis Alias
  • 23
  • 2
  • 7
0
votes
2 answers

Insert with select, dependent on the values in the table inserting into EDITED

So I need to figure out how to insert into a table, from another table, with a where clause that requires me to access the table that I am inserting into. I tried an alias from the table I am inserting into, but I quickly found out that you cannot…
Alexis Alias
  • 23
  • 2
  • 7
0
votes
1 answer

Issue in loading Timestamp and Time valued attributes in Hana (Attribute Load Failed Error)

I am trying to do a simple select * operation on column store tables in HANA Database. I observed that doing a select * on some of the tables in Database was resulting in the following error : column store error: search table error: [6923]…
Shubha Lakshmi
  • 127
  • 2
  • 2
  • 15
0
votes
1 answer

HANA JDBC Metadata

The HANA JDBC driver returns a different metadata type for a column when a union is performed even if both columns in the union have the same type. Consider the case below : create table test ( A NCHAR(1), B NCHAR(1) ); insert into test…
user7981386
  • 91
  • 1
  • 1
  • 5
0
votes
2 answers

Split the comma separated column into distinct rows in SAP HANA

tags column in my below table is comma separated and I need to split it into distinct rows as shown below. I have seen multiple links on the forum but most of the combinations of functions doesn't work in SAP HANA. Any help would be highly…
Nitin Pal
  • 21
  • 1
  • 6
0
votes
2 answers

HANA : column store error: search table error: Instantiation of calculation model failed

In HANA I built a Calculation view which executes fine. I have a calculated column. Now I changed the calculated column from case when "Anzahl" > 1000000 then 'SUSPECT: Too high?' when "Anzahl" < 1000 then 'SUSPECT: Too low?' else…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

Pass input parameter as a filter to a column derived from table input parameter

How to pass a input parameter (Date) as a filter condition to a column to a different input parameter which is derived from table type.
Vakas
  • 1
  • 1
1 2 3
…
99 100