Skip to Content

Unable to download/export VBRK, billing related table from hana studio

Hi,

I was trying to download billing data from VBRK table from hana studio for 3 months date range and totally there are more than 8.5Lakhs plus invoice data available in the table.

I tried by right clicking the table, export to local machine.

However, I get the following errors:

"

SAP DBTech JDBC: [2048]: column store error: table export failed:  [30146] Too big for client export. Please use server-local export.;A file exceeds maximum size for remote export (2048MB):

"

Even I tried to display data through SQL Query statement but I could get only 1000 records if I check it from data preview of VBRK table through SQL querying.  However, I get a count of more than 8.5Lakhs.

Kindly show me the way on how to download such a huge data from Hana studio.

We've Hana version: 1.0.70.

Regards,

Antony Jerald.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 27, 2014 at 02:05 PM

    Exporting to the hana server also has that limitation? i think you might have tried to export to desktop right?

    or

    if you are using hdbsql you can use \o command to write the results to the file you want.

    Regards,

    Krishna Tangudu

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2014 at 06:25 PM

    You can try as suggested by Krishna. I would also recommend the server export, but the question is "why do you want to do that". 😊

    What you might do with 850,000 + records on the desktop, that you cannot do directly in HANA.

    Ravi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2014 at 08:14 AM

    In addition to Ravi, even if you export the required data on server,  you cannot simply download it on desktop until you can access the SAP HANA Box via FTP connected using some FTP client.

    Regards

    Kumar 😊

    Add comment
    10|10000 characters needed characters exceeded