Skip to Content
0
Jun 14, 2018 at 07:38 PM

How to get complete length CLOB object from Hana table from python?

1414 Views

Hello,

I have a table in Hana with type CLOB. When I do a select query from python to fetch data from the table, only part of the string stored in the column is getting fetched. if I debug I can see this:

<Clob length: 27499 (currently loaded from hana: 1024)>

How to load full length Clob?

I changed catalog settings in Hana workbench as shown below:

My python code is:

cursor = connection.cursor()
cursor.execute('select * from IMAGE_TOOL.digitalist_images')
rows=cursor.fetchall()

Attachments

screenshot-25.png (48.6 kB)