1,967 questions
1
vote
2
answers
48
views
Elusive Error "JDBC: [339]: invalid number: SQL error" in HANA SQL
My goal is selecting values using a WHERE clause on HANA SQL.
My_Table contains a column PartnerID of type NVARCHAR that stores an integer number.
The following works fine:
SELECT * FROM "...
- 103
0
votes
2
answers
75
views
AMDP Unable to use UNION ALL with local tables - sql syntax error: incorrect syntax near "UNION
I have a requirement to create a table for 2 columns: first date of the month and the last day of the respective month. The last day calculation works correctly but I am not able to merge the results ...
- 1,008
1
vote
0
answers
25
views
PDO_ODBC not returing same data as odbc_* functions
I'm not able to return same data with PDO functions and with ODBC_* functions. With the same driver.
The database is SAP HANA.
Code:
$driver = 'HDBODBC';
$host = "XX.XX.XX.XX:...
- 406
0
votes
1
answer
57
views
Performance implications of INSERT INTO...SELECT :NEW.FIELD FROM DUMMY
Let's say we have a table BASE in a HANA:
CREATE COLUMN TABLE BASE
("CLIENT" NVARCHAR(3) DEFAULT '000' NOT NULL ,
"KEY" DECIMAL(21,7) CS_FIXED DEFAULT 0 NOT NULL ,
"...
- 53
0
votes
0
answers
48
views
Requests per second(RPS) not going above certain number with Hana database and Locust
I wanted to perform some load testing on Hana database. For this I decided to use Locust and I referenced the implementation given in this link for another database:
https://community.cratedb.com/t/...
- 389
0
votes
1
answer
44
views
Update Set for a column
This is a sample table and I would like to update the column 'TYPE' as like the value which is there 'STOCKIN' /'STOCKOUT' for the particular DOCNUM in each row.
Sample Table
CODE
DOCNUM
TYPE
Z01
...
0
votes
0
answers
90
views
Error: SAP DBTech JDBC: [2048]: column store error: search table error: [34023] Instantiation of calculation model failed; exception 306108
In HANA, I built the calculation view, where it is the external view from the HANA DSO. In the DSO, the data preview is fine and does not throw error, but the same data preview done on Calculation ...
- 160
0
votes
0
answers
32
views
Couldnt connect to SAP HANA via JDBC using apache dbcp2(connection pool)
I am trying to connect to SAP HANA cloud database. But getting error like
java.sql.SQLException: Error preloading the connection pool
at org.apache.commons.dbcp2.BasicDataSource.createDataSource(...
- 1
1
vote
1
answer
82
views
ABAP select with primary key in HANA applying condition to whole primary key
Is there a way to implement a full primary key select? I will explain it in more detail in the following lines.
I have to process all records of a table in sequence, using cursors, if the process ends ...
- 11
0
votes
1
answer
59
views
Query - Same Tables Twice
This is from SAP Business One - Hana database but the concept is the same for SQL.
I have a query that lists all of the invoices and payments in the system.
SELECT T2."TotalExpns" AS "...
- 11
1
vote
1
answer
47
views
Connect to a Hana database through a jar file from a php script
I'm having some issues to use the jar file ngdbc.jar. First of all, I need to do queries to a Hana database often, but since I'm developing with PHP and not able to get the proper drivers for it, I ...
- 113
0
votes
1
answer
56
views
HANA SQL CHAR25 with value 1/19/2017 2:28 PM ( example ) to DATE
I have a table ZCRM_DATA
Column - MODIFIED_DATE . Type - CHAR25
Values in column MODIFIED_DATE =
1/19/2017 2:28 PM
11/16/2018 2:44 PM
3/22/2019 12:52 PM
While selecting using data from this table how ...
- 109
0
votes
1
answer
112
views
Can we connect Views in SAP HANA to Tableau Desktop?
Ok, so I think this is a simple question, but I would like to know that if I create some views in SAP HANA using SQL, and want to connect with Tableau, will those views be available, or does Tableau ...
-2
votes
1
answer
44
views
Database schemas export issue
We are currently using an Azure Marketplace image for our SAP HANA Express instance for development purposes. I need to migrate the database schemas from one Azure account to another, but I'm facing ...
0
votes
0
answers
89
views
EXPORT INTO raising syntax errors in AMDP procedure
I am trying to upload the data from SAP tables to GCS Storage bucket and followed the documentation provided in EXPORT INTO Statement (Data Import Export), however when I try to implement the same in ...
0
votes
0
answers
100
views
SAP HANA: Connection to database server lost; check server and network status [System error: null]
We are using SAP HANA to perform some high volume transaction via our Java application using ngdbc driver. We are seeing some intermittent connection failure issues with the below JDBC exception.
...
- 378
0
votes
1
answer
41
views
How to store "export into" command in stored procedure
I am working on SAP HANA BTP Cockpit. I created 1 instance and enter in database explorer. There I created 1 table and transfer that table to AWS S3 bucket using this command:
Export into '<s3-...
- 1
0
votes
0
answers
113
views
issues with [%0] in SAP B1 Hana Query
I used [%0] to call a selection criteria on SAP B1 that looks like this:
The query looks like this:
SELECT
'Handshake' AS "Link"
FROM OITM T0
WHERE T0."ItmsGrpCod&...
- 13
0
votes
0
answers
42
views
Querying Data From Salesforce to SAP BW/4HANA by SAP PI/PO as middleware?
I am new to SAP PI/PO. I want to know the steps to fetch the data from Salesforce to SAP BW/4HANA by SAP PI/PO as middleware. My case is that I have to pass a SOQL query to salesforce using rest API ...
1
vote
1
answer
59
views
How to prompt query selection criteria with just Year
I'm trying to get just the year in the following table with timestamps. Which is usually possible using Year(), but somehow I can't get it to work on query selection criteria thing:
I tried to cast ...
- 13
0
votes
1
answer
226
views
Issues connecting to SAP Hana Cloud DB for Vector embeddings
I've been following a blog on RAG with SAP HANA Cloud Vector Engine, GenAI Hub & CAP, pulled the Git Rep and following the instructions in the README.
The AI-Core part works fine and is connecting ...
- 2,210
0
votes
1
answer
358
views
How to set limit connections per user in SAP HANA?
The task is to write a request that will receive the number of connections for the current user. As well as a request that will set a different value for the database SAP HANA.
I did not find anything ...
0
votes
1
answer
145
views
SAP HANA native procedural SQL, create function within a function doesn't work
I would like to create a function within a function in native SAP HANA SQL
CREATE or REPLACE FUNCTION my_func (pi_param VARCHAR(1))
RETURNS v_return varchar(10) AS
BEGIN
DECLARE ....;
DECLARE ....;...
- 3
0
votes
2
answers
72
views
SQL Data Group and Formating
I have a table like the one on the left. I want to transform this table into the one on the right. Is it possible with SQL? If so, how can I do it?
First cvn = Lowest score for
Last cvn = Highest ...
- 1
2
votes
0
answers
132
views
temp index create error when running HANA subquery?
I wrote an AMDP method, and when I run the method, I get the following DUMP.
Error while executing a database procedure
During execution of database procedure
ZCL_MM_REPORTE_INV_AMDP=\>...
- 41
1
vote
1
answer
72
views
Making totals from two queries?
I am trying to calculate the space in a warehouse bin location.
I have the following data:
Table 1
Bin Location Item Quantity Total Spots Used
000-A-006 ABC1 100 2
...
- 11
0
votes
1
answer
72
views
How to build WHERE condition based on a calculated field?
I have this query that pulls data from the inventory bin location and a user defined field that shows the max number of pallets per warehouse.
My data:
Bin Code Max Pallets Total Pallets ...
- 11
1
vote
0
answers
172
views
Extract BW/4HANA using Python vs exporting data directly
I am trying to explore the option of exporting data from BW/4HANA to AWS S3 in flat file format.
I have two options
Open Hub
Use Python
I checked with SAP BW consultant in my company. He said I can'...
- 207
0
votes
1
answer
128
views
dynamic conversion of Decimal(38,18)data type that converts from default decimal datatype in ADF
ADF copy activity by default converts decimal datatype to decimal(38,18) , how can I overcome it to use original datatype decimal as source for multiple tables dynamically with different schemas for ...
1
vote
1
answer
353
views
Fetch multiple SAP Tables to Azure Data Factory?
I am trying to connect multiple SAP tables in ADF. I have a SAP table connector with dataset but I am not able to connect multiple tables with this. It is working for a single table without any error. ...
- 179
0
votes
0
answers
21
views
Is there any way to connect GCP DAG Executions to SAP HANA?
In our project we want to connect GCP Dag's to make automatic executions based on some data retrieved from SAP HANA (table counts)
Basically that, anyone know any way to do this? We want the DAG's to ...
0
votes
1
answer
69
views
M Code of UTF-32 Encoded Emoji in Power Query is not processed by SAP HANA
I wrote this M code in Power Query to create a column whose cells contain this emoji 🚢:
#"Added Column" = Table.AddColumn(#"PreviousStep", "Column Name", each Character....
0
votes
1
answer
57
views
SQL Cursor multiply two sets of lines
I am using Hana data studio (SQL) and need to write a cursor that takes the original dataset, makes column age set to 0 and sets the the fiscal quarter to the iterated value over a distinct list of ...
0
votes
1
answer
53
views
HANA returns Formatted Values through hdbcli
HANA Studio has a default format option (Preferences>Runtime>Result>'Format Values').
Ex:
A View Column of Decimal(13,3) outputs 30 in Data Preview with 'Format Values' setting, and 30.000 ...
- 1
0
votes
1
answer
196
views
Not getting all the distinct values into the FOR Loop?
I am trying to fetch Distinct values into the For loop in SAP HANA using CURSOR and For Loop and I am not getting all the distinct values into the For Loop. Instead of getting 10 distinct names, I am ...
- 11
0
votes
1
answer
46
views
Hana SQL , Is there a way to use mapping/setup table of constants?
Is there a way use mapping table instead of hardcoding of values and their replacements?
mapping table
value
replacement
N
Module Not turned In
PC
Pending Corrections
LT_REVIEW_STATUS = SELECT ...
- 1
0
votes
0
answers
113
views
Delete SAP HANA Views
Is there a way to schedule deletion of sap hana views after a period of time ? We have one requirement where developers create temporary views and forgot to delete those. In such cases we are facing ...
- 1
0
votes
1
answer
1k
views
Is there any currency conversion function in GCP Bigquery?
I'm trying to migrate a procedure from SAP HANA to GCP bigquery.
The procedure in HANA uses a native function - CONVERT_CURRENCY in HANA which allows me to provide a historical date and it gives me ...
- 21
0
votes
0
answers
213
views
How to implement a encrypted connection to a SAP Hana DB instance in Java
I am trying to use the Java JDBC driver for SAP Hana DB to connect to a Hana database with an encrypted connection. I have configured the driver with a JDBC connection string in the manner that the ...
- 189
0
votes
0
answers
59
views
Hana SQL SAP DSP , can't use standard functions
I am about to use standard functions and libraries of HANA Cloud SQL in the table function of SAP DSP. Looks like that none of these functions can be used.
For example, I would like to use the ...
- 1
0
votes
1
answer
460
views
SAP HANA, query to check the size of the FullBackup as displayed in the HANA Studio backup catalog
I need help in creating an SQL query that can retrieve the size occupied by the latest FullBackup in HANA Studio. I haven't been able to find this SQL query in any forum or SAP note. Any ideas on how ...
0
votes
0
answers
459
views
Why can't I connect to the Hana database through Python but can through Hana Studio?
I have the following setup in Hana Studio and the connection works:
As you can see I selected "Multiple containers" and "Tenant database".
My python code is:
from hdbcli import ...
0
votes
1
answer
297
views
HANA Global Temporary tables 'Could not find table/view' error
From HANA Studio, I run
select * from M_TEMPORARY_TABLES
shows that user1 has global temporary table called '#SDE_LOGFILE'.
But when I try 'select * from user1.#SDE_LOGFILE' I get error 'SAP DBTech ...
- 11
0
votes
0
answers
86
views
How to ingest data from HANA to postgres?
This is a very basic question, but I am new to Postgres and want to ingest some data from HANA views. Something like:
1. Run queries/stored procedure to extract/join data stored in HANA
2. Bring into ...
- 3,707
0
votes
0
answers
110
views
How to derive the hierarchy output using HANA SQL?
I came across some below hierarchical requirement. I have two columns called COL1 and COL2 and want to derive the value (MAP).
COL1 and COL2 have 4 types of relationships i.e. 1:1, 1:M, M:1, M:M.
...
2
votes
0
answers
208
views
How to connect SAP BW to Jupyter Notebook
I need to connect some procedures located on SAP BW (SAP HANA DB) with a data science platform containing Jupyter Notebooks. The goal is to exploit SAP BW data from Jupyter Notebooks for analysis.
I ...
- 21
-1
votes
2
answers
30
views
How to get final inserted sql records count using python
I have script where i can read data and did transformation and inserted to database using python
But transformed data is inserting loop wise so when i try to get cursor.rowcount it showing every ...
0
votes
3
answers
140
views
In SQL how to validate dynamic key-value pairs against key-value columns
I have a SQL table that contains key - value pairs, looks like this:
Key
Value
product_id
iphone_14
product_id
iphone_14_pro
country_code
USA
country_code
CA
Those rows identify allowed key-...
- 588
-1
votes
1
answer
321
views
Using Python How To Insert Data To Sap Hana Table
I connected sap hana table while inserting data to hana table getting below error
Error inserting data: (260, 'invalid column name: LOADDT')
Below is the insert query using python
tgt_query = '''
...
1
vote
1
answer
139
views
Why DELETE after CTE fails with Syntax error?
I have a SAP HANA SQL query with two Common CTE's and followed by delete SQL on a regular Table. The SQL execution fails with incorrect syntax. Below is the error code and the HANA SQl script.
WITH ...
- 11