hive中CASCADE关键字用来干什么的

CASCADE关键字,通常在更改表结构的语句之后出现,它的作用就是让hive去刷新历史数据,比如你在新增一个表字段的时候,你不加CASCADE关键字,就会造成表中已有数据的对应该字段为NULL,甚至有的时候旧的数据不认这个字段,因此在更改表结构的时候要带上这个关键字

Hive的保留关键字包括:ADD,ADMIN,AFTER,ALL,ALTER,ANALYZE,AND,ARCHIVE,ARRAY,AS,ASC,BEFORE,BETWEEN,BIGINT,BINARY,BOOLEAN,BOTH,BUCKET,BUCKETS,BY,CASCADE,CASE,CAST,CHANGE,CLUSTER,CLUSTERED,CLUSTERSTATUS,COLLECTION,COLUMN,COLUMNS,COMMENT,COMPACT,COMPACTIONS,COMPUTE,CONCATENATE,CONF,CONTINUE,CREATE,CROSS,CURRENT,CURRENT_DATE,CURRENT_TIMESTAMP,DATA,DATABASE,DATABASES,DATE,DATETIME,DAY,DBPROPERTIES,DECIMAL,DEFERRED,DEFINED,DELIMITED,DEPENDENCY,DESC,DESCRIBE,DFS,DIRECTORIES,DIRECTORY,DISABLE,DISTRIBUTE,DIV,DROP,ELSE,ENABLE,END,ESCAPED,EXCLUSIVE,EXISTS,EXPLAIN,EXPORT,EXTENDED,EXTERNAL,FAILED,FALSE,FETCH,FIELDS,FILE,FILEFORMAT,FIRST,FOLLOWING,FOR,FROM,FULL,FUNC,FUNCTION,GE,GENERATE,GET,GLOBAL,GRANT,GROUP,GROUPING,HAVING,HOLD_DDLTIME,HOUR,IDX,IF,IGNORE,IMPORT,IN,INCLUDE,INDEX,INDEXES,INNER,INPATH,INPUTDRIVER,INPUTFORMAT,INSERT,INTERSECT,INT,BIGINTO,BIGINTO,BIGINTO,BIGINTO,BIGINTO,BIGINTO,BIGINTO,BIGINTO,IOSFORMATTED,IOWRITE,KAFKA,KEYS,KILL,LARGE,LAST,LEFT,LIMIT,LINES,LIST,LOCATION,LOCK,LOCKS,LOGICAL,MAP,MAPJOIN,MAPRED,MASTER,MATCHED,MATERIALIZE,MERGE,MINUS,MINUTE,MONTH,MSCK,NATIVE,NATURAL,NO,NOT,NULL,NULLS,OF,OFFLINE,OFFSET,OLD,ON,ONLY,OPEN,OR,ORDER,OUT,OUTER,OUTPUTDRIVER,OUTPUTFORMAT,OVER,OVERWRITE,OWNER,PARTIALSCAN,PARTITION,PARTITIONED,PARTITIONS,PERCENT,PLUS,PRECEDING,PRECISION,PRESERVE,PRETTY,PRINT,PROCEDURE,PROTOSHUFFLE,PUBLIC,RAWREAD,RAWWRITE,RCFILE,READ,READONLY,READS,REBUILD,RECORDREADERCLASS,RECORDREPLACEMENTCHARACTER,RECORDWRITERCLASS,REDUCE,REGEXP,RELOAD,RENAME,REPAIR,REPLACE,REPLICATION,RESTRICT,RESUME,RETURN,RETURNS,REVOKE,RIGHT,RLIKE,ROLE,ROLES,ROLLBACK,ROLLUP,ROW,ROWS,SCHEMA,SELECT,SEQUENCEFILE,SEPARATOR,SERDE,SERDEPROPERTIES,SET,SHARED,SHOW,SHUTDOWN,SKIP,SMALLINT,SORT,SORTED,START,STATS,STATUS,STRAIGHT_JOIN,STRING,STRUCT,TABLE,TABLES,TABLESAMPLE,TBLPROPERTIES,TEMPORARY,TERMINATED,THEN,TIME,TIMESTAMP,TINYINT,TO,TOUCH,TRAILING,TRANSACTION,TTL,TUPLE,TYPE,TYPES,UNARCHIVE,UNBOUNDED,UNCACHE,UNION,UNIQUE,UNLOCK,UNSET,UNSIGNED,UPDATE,URI,USE,USER,USING,UTC,UTCTIMESTAMP,VALUE,VALUED,VALUES,VARCHAR,VIEWS,WHEN,WHERE,WHILE,WINDOW,WITH,WORK,WRITE,YEAR.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值