All Forums Database
sakthikrr 53 posts Joined 07/12
16 Sep 2015
create table with JSON datatype

Hi Experts,
I am unable to create a table with JSON datatype column. My TD version is

CREATE volatile TABLE my_table (eno INTEGER, edata JSON(100)) on commit preserve rows;


Teradata SQL Assistant


3706:  Syntax error: Data Type "JSON" does not match a Defined Type name. 





ulrich 816 posts Joined 09/09
16 Sep 2015

JSON was introduced at TD15.0 - so it is not available at the 14.0...

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.