I have event, cases and roads tables. I want to join these 3 tables but i have a problem because there is two different road_id which matched same firstpoint, l
I use a HANA 2.0 database. I want to export a table or a sql query from the database to an external client as fast as possible and using a command line (i'm on
I have a script that starts with import pandas as pd from sqlalchemy import create_engine, text hana_engine = create_engine(os.getenv('RCF_HANA_URI'), echo=Fal
I've a Hana table having 220 million records. (Size 12GB). We currently use Informatica which performs a select * on my_table and exports a pipe separated data
In SAP HANA I can use filters as SQL or Column Store expression within a modelling view (e.g. Calculation View). I chose SQL. Filter I tried: gueltig_bis >
I have the following query in postgres which gives the meter range and the number of vehicles travelled between the range SELECT (CASE WHEN meter >= 0 AND m
it it possible to write script in hana that crate temporary table that is based on existing table (with no need to define columns and columns types hard coded