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 14.0.0.1

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

Error:
---------------------------

Teradata SQL Assistant

---------------------------

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

---------------------------

OK   

---------------------------

 

Sakthi
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.