Skip to Content

Issues in BLOB data type In COLUMN Store Table


I had row store table with blob data type where i was able to insert images in table in blob data type column , i was able to update blob data type too for same inserted record. The image size is not more than 2 GB.

The two scenarios were possible on this table :

1) Insert large image and then update the inserted image with smaller size image .

2) Insert small size image and then update inserted image with large image.

I changed table from row store to column store just to test the performance of table.

I inserted large size image , and tried to update this with smaller size image. The update is successful.

I inserted the small size image , but i am unable to update the small size inserted image with large size image.

Any reason why update is failing in this column store scenario .

I am doing this image testing in java code.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 07, 2016 at 06:31 AM

    Ok, without your code and the error messages you receive for the update, all we can do here is to be sorry for you 😔

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Lars

      I looked into Index server log and found following log specific to transaction that i am running.

      [1491]{-1}[-1/-1] 2016-09-07 12:07:42.937946 i SQLSessionCmd : canceled transaction still not finished (cancelation might be still on-going): transaction id=77, update trans id=0, sql_string=, statement_hash=, user_name=INF188861, conn_id=449771, thread_id=0, app_user_name=, app_name=, app_source=

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.