本篇文章主要介绍了" Redshift 通过重新建表修改varchar60 到varchar90",主要涉及到方面的内容,对于其他数据库感兴趣的同学可以参考一下:
首先需要知道的是redshift不支持SQL语法直接修改varchar(60) 到varchar(90),但PostgreSQL和MySQL都支持。1.Post...
entity_id character varying(300),
utc_timestamp timestamp without time zone,
time_zone character varying(60),
ad_id character varying(60),
os_version character varying(20),
connection_type character varying(10),
device_make character varying(20),
device_model character varying(50),
gps_state character varying(10),
map_source character varying(10),
current_lat numeric(15,6),
current_lon numeric(15,6),
altitude numeric(15,6),
horizontal_accuracy numeric(15,6),
vertical_accuracy numeric(15,6),
nav_timestamp timestamp without time zone,
speed numeric(15,6),
assumed_speed numeric(15,6),
traffic_speed numeric(15,6),
heading character varying(50),
edge_id character varying(20),
trigger character varying(30),
type character varying(50),
display_screen character varying(50),
vendor character varying(20),
incident_vendor character varying(20),