Category "hana"

m1 macos can't install hdbcli

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

Exporting a hana table having 220 million records using hana Export Command

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

SAP HANA filter DATE column with current date / now

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 >

How to make case in HANA

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

Temporary tables in hana

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