spark中case when出错

[sisteryaya]

显示错误：
pyspark.sql.utils.AnalysisException: 'org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe: columns has 13 elements while columns.types has 7 elements!);'

图一为我的程序，图二为table：train16_19
我想修改 time 那一列，用日代替年月日时，如：2014-12-16 18 改为16

请各位指点一下，感谢！

[sisteryaya]

已解决。 spark.sql("CREATE TABLE day16_19 AS \ SELECT user_id,item_id,behavior_type,case when substr(time,1,10)='2014-12-16' then 16 \ when substr(time,1,10)='2014-12-17' then 17 \ when substr(time,1,10)='2014-12-18' then 18 else 0 end as day from user_test")