python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
How do i use STRING_AGG and avoid duplicate values?
I face the following problem: in a SQL table i have stored Information about persons, date and diseases.
CREATE TABLE Diseases (person varchar(80), time date, disease varchar(80))
INSERT INTO Disease...
Philipp Schulz
Votes: 0
Answers: 1
Make pandas.to_sql to create tables with lowercase table name in SAP HANA database
Simple, i just want to create lowercase tables with pandas.to_sql. Tried the following:
df.to_sql(name=hdb_table_name.lower(), schema="SCHEMA_NAME", con=hdb_connection, index=True, if_exists...
sony
Votes: 0
Answers: 2
SAP HANA: Connect to systemdb on worker/slave node
I have a 2 node sap hana scale-out setup. I'd like to connect on the worker node(Node2) on database systemdb using hdbsql. However I get the below error while connecting on Port 3xx13:
* -10709: Conne...
Mariya
Votes: 0
Answers: 1
Assigning a HANA hierarchy query to a table variable leads to inconsistent results
Context
I want to use the HANA HIERARCHY_TEMPORAL function to work on a SAP KNVH hierarchy with time intervals ;
When simply used in a SELECT query, this works fine ;
When otherwise using the very sam...

Frederi ROSE
Votes: 0
Answers: 2