on 06-22-2018 12:38 PM
Good Day Experts,
I'm running HANA Query on Calculation View in HANA Studio, It's a detail report getting output almost 1.5 million records. Please assist me is there any way i can directly save the output into a text file on desktop?
Your quick response is highly appreciated.
Thanks & Regards,
Raj
Hi,
You could use hdbsql to run your query and get out put to a file in a server with HANA client installed.
Firstly, create a file which contains your query e.g. query.sql
Then run hdbsql command to generate out put into out.txt
hdbsql -n <hostname>:<sqlport> -u <dbuser> -p <password> -I query.sql -o out.txt
You could run hdbsql -h to show help of this command.
Best Regards,
Eason Chen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the response.
Is there any other way? Directly coping the SQL Query output into the text file.
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One option is , You can use export SQL, and use that in hdbsql if this data extraction is on- going,
Other option is ,you can insert the output into temporary physical table and export that from Hana studio, of course when it is not on-going.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.