spark.sql.sources.DataSourceRegister 的自定义实现的完全限定的类名

参数注释:IF NOT EXISTS:如果数据库中已存在同名的表,则不会执行任何操作。USING data_source:用于表的文件格式,data_source 必须是 TEXT、CSV、JSON、JDBC、PARQUET、ORC、HIVE、DELTA 或 LIBSVM 中的一个,或 org.apache.spark.sql.sources.DataSourceRegister 的自定义实现的完全限定的类名。支持使用 HIVE 创建 Hive SerDe 表。 你可以使用 OPTIONS 子句指定 H
摘要由CSDN通过智能技术生成

参数注释:

IF NOT EXISTS:如果数据库中已存在同名的表,则不会执行任何操作。
USING data_source:用于表的文件格式,data_source 必须是 TEXT、CSV、JSON、JDBC、PARQUET、ORC、HIVE、DELTA 或 LIBSVM 中的一个,或 org.apache.spark.sql.sources.DataSourceRegister 的自定义实现的完全限定的类名。支持使用 HIVE 创建 Hive SerDe 表。 你可以使用 OPTIONS 子句指定 Hive 特定的 file_format 和 row_format,这是不区分大小写的字符串映射。选项键为 FILEFORMAT、INPUTFORMAT、OUTPUTFORMAT、SERDE、FIELDDELIM、ESCAPEDELIM、MAPKEYDELIM 和 LINEDELIM。
OPTIONS:用于优化表的行为或配置 HIVE 表的表选项。
PARTITIONED BY (col_name1, col_name2, …):按指定的列对创建的表进行分区,将为每个分区创建一个目录。
CLUSTERED BY col_name3, col_name4, …):按照指定的列,把表中的分区分割到固定数目的 Bucket中,该选项通常与分区操作配合使用。delta格式的文件不支持该子句。
SORTED BY:数据在buckets中的排序方式,默认是升序ASC。
INTO num_buckets BUCKETS:bucket是一个优化技术,使用bucket(和bucket 列)来确定数据的分区,并避免数据洗牌(data shuffle),使数据变得有序。
LOCATION path:用于存储表数据的目录,可以指定分布式存储上的路径。
AS select_statement:使用来自 SELECT 语句的输出数据填充该表。
2,使用Delta Lake(增量Lake)创建表

用户可以使用标准的CREATE TABLE命令来创建存储在delta lake中的表,除了标准的创建delta table的命令之外,还可以使用以下的语法来创建delta表:参数注释:

IF NOT EXISTS:如果数据库中已存在同名的表,则不会执行任何操作。
USING data_source:用于表的文件格式,data_source 必须是 TEXT、CSV、JSON、JDBC、PARQUET、ORC、HIVE、DELTA 或 LIBSVM 中的一个,或 org.apache.spark.sql.sources.DataSourceRegister 的自定义实现的完全限定的类名。支持使用 HIVE 创建 Hive SerDe 表。 你可以使用 OPTIONS 子句指定 Hive 特定的 file_format 和 row_format,这是不区分大小写的字符串映射。选项键为 FILEFORMAT、INPUTFORMAT、OUTPUTFORMAT、SERDE、FIELDDELIM、ESCAPEDELIM、MAPKEYDELIM 和 LINEDELIM。

http://m.itangyuan.com/book/chapter/15891977/65177908.html
http://www.itangyuan.com/book/chapter/15891977/65177909.html
http://m.itangyuan.com/book/chapter/15891977/65177909.html
http://www.itangyuan.com/book/chapter/15891977/65177910.html
http://m.itangyuan.com/book/chapter/15891977/65177910.html
http://www.itangyuan.com/book/chapter/15891977/65177911.html
http://m.itangyuan.com/book/chapter/15891977/65177911.html
http://www.itangyuan.com/book/chapter/15891977/65177914.html
http://m.itangyuan.com/book/chapter/15891977/65177914.html
http://www.itangyuan.com/book/chapter/15891977/65177915.html
http://m.itangyuan.com/book/chapter/15891977/65177915.html
http://www.itangyuan.com/book/chapter/15891977/65177916.html
http://m.itangyuan.com/book/chapter/15891977/65177916.html
http://www.itangyuan.com/book/chapter/15891977/65177917.html
http://m.itangyuan.com/book/chapter/15891977/65177917.html
http://www.itangyuan.com/book/chapter/15891977/65177918.html
http://m.itangyuan.com/book/chapter/15891977/65177918.html
http://www.itangyuan.com/book/chapter/15891977/65177921.html
http://m.itangyuan.com/book/chapter/15891977/65177921.html
http://www.itangyuan.com/book/chapter/15891977/65177922.html
http://m.itangyuan.com/book/chapter/15891977/65177922.html
http://www.itangyuan.com/book/chapter/15891977/65177923.html
http://m.itangyuan.com/book/chapter/15891977/65177923.html
http://www.itangyuan.com/book/chapter/15891977/65177924.html
http://m.itangyuan.com/book/chapter/15891977/65177924.html
http://www.itangyuan.com/book/chapter/15891977/65177925.html
http://m.itangyuan.com/book/chapter/15891977/65177925.html
http://www.itangyuan.com/book/chapter/15891977/65177927.html
http://m.itangyuan.com/book/chapter/15891977/65177927.html
http://www.itangyuan.com/book/chapter/15891977/65177928.html
http://m.itangyuan.com/book/chapter/15891977/65177928.html
http://www.itangyuan.com/book/chapter/15891977/65177930.html
http://m.itangyuan.com/book/chapter/15891977/65177930.html
http://www.itangyuan.com/book/chapter/15891977/65177931.html
http://m.itangyuan.com/book/chapter/15891977/65177931.html
http://www.itangyuan.com/book/chapter/15891977/65177932.html
http://m.itangyuan.com/book/chapter/15891977/65177932.html
http://www.itangyuan.com/book/chapter/15891977/65177933.html
http://m.itangyuan.com/book/chapter/15891977/65177933.html
http://www.itangyuan.com/book/chapter/15891977/65177934.html
http://m.itangyuan.com/book/chapter/15891977/65177934.html
http://www.itangyuan.com/book/chapter/15891977/65177936.html
http://m.itangyuan.com/book/chapter/15891977/65177936.html
http://www.itangyuan.com/book/chapter/15891977/65177937.html
http://m.itangyuan.com/book/chapter/15891977/65177937.html
http://www.itangyuan.com/book/chapter/15891977/65177938.html
http://m.itangyuan.com/book/chapter/15891977/65177938.html
http://www.itangyuan.com/book/chapter/15891977/65177941.html
http://m.itangyuan.com/book/chapter/15891977/65177941.html
http://www.itangyuan.com/book/chapter/15891977/65177943.html
http://m.itangyuan.com/book/chapter/15891977/65177943.html
http://www.itangyuan.com/book/chapter/15891977/65177944.html
http://m.itangyuan.com/book/chapter/15891977/65177944.html
http://www.itangyuan.com/book/chapter/15891977/65177946.html
http://m.itangyuan.com/book/chapter/15891977/65177946.html
http://www.itangyuan.com/book/chapter/15891977/65177947.html
http://m.itangyuan.com/book/chapter/15891977/65177947.html
http://www.itangyuan.com/book/chapter/15891977/65177949.html
http://m.itangyuan.com/book/chapter/15891977/65177949.html
http://www.itangyuan.com/book/chapter/15891977/65177950.html
http://m.itangyuan.com/book/chapter/15891977/65177950.html
http://www.itangyuan.com/book/chapter/15891977/65177951.html
http://m.itangyuan.com/book/chapter/15891977/65177951.html
http://www.itangyuan.com/book/chapter/15891977/65177952.html
http://m.itangyuan.com/book/chapter/15891977/65177952.html
http://www.itangyuan.com/book/chapter/15891977/65177953.html
http://m.itangyuan.com/book/chapter/15891977/65177953.html
http://www.itangyuan.com/book/chapter/15891977/65177955.html
http://m.itangyuan.com/book/chapter/15891977/65177955.html
http://www.itangyuan.com/book/chapter/15891977/65177957.html
http://m.itangyuan.com/book/chapter/15891977/65177957.html
http://www.itangyuan.com/book/chapter/15891977/65177958.html
http://m.itangyuan.com/book/chapter/15891977/65177958.html
http://www.itangyuan.com/book/chapter/15891977/65177959.html
http://m.itangyuan.com/book/chapter/15891977/65177959.html
http://www.itangyuan.com/book/chapter/15891977/65177960.html
http://m.itangyuan.com/book/chapter/15891977/65177960.html
http://www.itangyuan.com/book/chapter/15891977/65177963.html
http://m.itangyuan.com/book/chapter/15891977/65177963.html
http://www.itangyuan.com/book/chapter/15891977/65177964.html
http://m.itangyuan.com/book/chapter/15891977/65177964.html
http://www.itangyuan.com/book/chapter/15891977/65177965.html
http://m.itangyuan.com/book/chapter/15891977/65177965.html
http://www.itangyuan.com/book/chapter/15891977/65177967.html
http://m.itangyuan.com/book/chapter/15891977/65177967.html
http://www.itangyuan.com/book/chapter/15891977/65177968.html
http://m.itangyuan.com/book/chapter/15891977/65177968.html
http://www.itangyuan.com/book/chapter/15891977/65177969.html
http://m.itangyuan.com/book/chapter/15891977/65177969.html
http://www.itangyuan.com/book/chapter/15891977/65177972.html
http://m.itangyuan.com/book/chapter/15891977/65177972.html
http://www.itangyuan.com/book/chapter/15891977/65177974.html
http://m.itangyuan.com/book/chapter/15891977/65177974.html
http://www.itangyuan.com/book/chapter/15891977/65177975.html
http://m.itangyuan.com/book/chapter/15891977/65177975.html
http://www.itangyuan.com/book/chapter/15891977/65177976.html
http://m.itangyuan.com/book/chapter/15891977/65177976.html
http://www.itangyuan.com/book/chapter/15891977/65177978.html
http://m.itangyuan.com/book/chapter/15891977/65177978.html
http://www.itangyuan.com/book/chapter/15891977/65177980.html
http://m.itangyuan.com/book/chapter/15891977/65177980.html
http://www.itangyuan.com/book/chapter/15891977/65177981.html
http://m.itangyuan.com/book/chapter/15891977/65177981.html
http://www.itangyuan.com/book/chapter/15891977/65177984.html
http://m.itangyuan.com/book/chapter/15891977/65177984.html
http://www.itangyuan.com/book/chapter/15891977/65177985.html
http://m.itangyuan.com/book/chapter/15891977/65177985.html
http://www.itangyuan.com/book/chapter/15891977/65177988.html
http://m.itangyuan.com/book/chapter/15891977/65177988.html
http://www.itangyuan.com/book/chapter/15891977/65177989.html
http://m.itangyuan.com/book/chapter/15891977/65177989.html
http://www.itangyuan.com/book/chapter/15891977/65177991.html
http://m.itangyuan.com/book/chapter/15891977/65177991.html
http://www.itangyuan.com/book/chapter/15891977/65177992.html
http://m.itangyuan.com/book/chapter/15891977/65177992.html
http://www.itangyuan.com/book/chapter/15891977/65177993.html
http://m.itangyuan.com/book/chapter/15891977/65177993.html
http://www.itangyuan.com/book/chapter/15891977/65177994.html
http://m.itangyuan.com/book/chapter/15891977/65177994.html
http://www.itangyuan.com/book/chapter/15891977/65177995.html
http://m.itangyuan.com/book/chapter/15891977/65177995.html
http://www.itangyuan.com/book/chapter/15891977/65177999.html
http://m.itangyuan.com/book/chapter/15891977/65177999.html
http://www.itangyuan.com/book/chapter/15891977/65178001.html
http://m.itangyuan.com/book/chapter/15891977/65178001.html
http://www.itangyuan.com/book/chapter/15891977/65178002.html
http://m.itangyuan.com/book/chapter/15891977/65178002.html
http://www.itangyuan.com/book/chapter/15891977/65178003.html
http://m.itangyuan.com/book/chapter/15891977/65178003.html
http://www.itangyuan.com/book/chapter/15891977/65178004.html
http://m.itangyuan.com/book/chapter/15891977/65178004.html
http://www.itangyuan.com/book/chapter/15891977/65178005.html
http://m.itangyuan.com/book/chapter/15891977/65178005.html
http://www.itangyuan.com/book/chapter/15891977/65178007.html
http://m.itangyuan.com/book/chapter/15891977/65178007.html
http://www.itangyuan.com/book/chapter/15891977/65178008.html
http://m.itangyuan.com/book/chapter/15891977/65178008.html
http://www.itangyuan.com/book/chapter/15891977/65178010.html
http://m.itangyuan.com/book/chapter/15891977/65178010.html
http://www.itangyuan.com/book/chapter/15891977/65178011.html
http://m.itangyuan.com/book/chapter/15891977/65178011.html
http://www.itangyuan.com/book/chapter/15891977/65178012.html
http://m.itangyuan.com/book/chapter/15891977/65178012.html
http://www.itangyuan.com/book/chapter/15891977/65178013.html
http://m.itangyuan.com/book/chapter/1

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值