当前位置： 首页 > news >正文

下沙做网站软件淘宝seo软件

news 2025/7/25 22:37:06
下沙做网站软件,淘宝seo软件,手机端网站建设的费用清单,企业品牌战略Spark SQL----INSERT TABLE 一、描述二、语法三、参数四、例子4.1 Insert Into4.2 Insert Overwrite 一、描述 INSERT语句将新行插入表中或覆盖表中的现有数据。插入的行可以由值表达式指定，也可以由查询结果指定。 二、语法 INSERT [ INTO | OVERWRITE ] [ TABL…

Spark SQL----INSERT TABLE

  • 一、描述
  • 二、语法
  • 三、参数
  • 四、例子
    • 4.1 Insert Into
    • 4.2 Insert Overwrite

一、描述

INSERT语句将新行插入表中或覆盖表中的现有数据。插入的行可以由值表达式指定，也可以由查询结果指定。

二、语法

INSERT [ INTO | OVERWRITE ] [ TABLE ] table_identifier [ partition_spec ] [ ( column_list ) ]{ VALUES ( { value | NULL } [ , ... ] ) [ , ( ... ) ] | query }INSERT INTO [ TABLE ] table_identifier REPLACE WHERE boolean_expression query

三、参数

  • table_identifier
    指定一个表名称，可以选择使用数据库名称对其进行限定。
    语法：[ database_name. ] table_name
  • partition_spec
    一个可选参数，用于指定分区的键值对的逗号分隔列表。请注意，可以在分区规范中使用类型化的文字（例如，date’2019-01-02’）。
    语法：PARTITION ( partition_col_name = partition_col_val [ , … ] )
  • column_list
    一个可选参数，用于指定属于table_identifier表的列的逗号分隔列表。Spark会根据指定的column列表对输入查询的列进行重新排序，以匹配表schema。
    注：当前行为有一些局限性：
    • 所有指定的列都应存在于表中，并且不能相互重复。它包括除静态分区列之外的所有列。
    • column列表的大小应该与VALUES子句或查询中的数据大小完全相同。
  • VALUES ( { value | NULL } [ , … ] ) [ , ( … ) ]
    指定要插入的值。可以插入显式指定的值或NULL。必须使用逗号分隔子句中的每个值。可以指定多个值集来插入多行。
  • boolean_expression
    指定计算结果为布尔型的任何表达式。可以使用逻辑运算符（AND, OR）将两个或多个表达式组合在一起。
  • query
    生成要插入的行的查询。它可以是以下格式之一：
    • SELECT语句
    • Inline Table语句
    • FROM语句

四、例子

4.1 Insert Into

使用VALUES子句进行单行插入

CREATE TABLE students (name VARCHAR(64), address VARCHAR(64))USING PARQUET PARTITIONED BY (student_id INT);INSERT INTO students VALUES('Amy Smith', '123 Park Ave, San Jose', 111111);SELECT * FROM students;
+---------+----------------------+----------+
|     name|               address|student_id|
+---------+----------------------+----------+
|Amy Smith|123 Park Ave, San Jose|    111111|
+---------+----------------------+----------+

使用VALUES子句进行多行插入

INSERT INTO students VALUES('Bob Brown', '456 Taylor St, Cupertino', 222222),('Cathy Johnson', '789 Race Ave, Palo Alto', 333333);SELECT * FROM students;
+-------------+------------------------+----------+
|         name|                 address|student_id|
+-------------+------------------------+----------+
|    Amy Smith|  123 Park Ave, San Jose|    111111|
+-------------+------------------------+----------+
|    Bob Brown|456 Taylor St, Cupertino|    222222|
+-------------+------------------------+----------+
|Cathy Johnson| 789 Race Ave, Palo Alto|    333333|
+--------------+-----------------------+----------+

使用SELECT语句插入

-- Assuming the persons table has already been created and populated.
SELECT * FROM persons;
+-------------+--------------------------+---------+
|         name|                   address|      ssn|
+-------------+--------------------------+---------+
|Dora Williams|134 Forest Ave, Menlo Park|123456789|
+-------------+--------------------------+---------+
|  Eddie Davis|   245 Market St, Milpitas|345678901|
+-------------+--------------------------+---------+INSERT INTO students PARTITION (student_id = 444444)SELECT name, address FROM persons WHERE name = "Dora Williams";SELECT * FROM students;
+-------------+--------------------------+----------+
|         name|                   address|student_id|
+-------------+--------------------------+----------+
|    Amy Smith|    123 Park Ave, San Jose|    111111|
+-------------+--------------------------+----------+
|    Bob Brown|  456 Taylor St, Cupertino|    222222|
+-------------+--------------------------+----------+
|Cathy Johnson|   789 Race Ave, Palo Alto|    333333|
+-------------+--------------------------+----------+
|Dora Williams|134 Forest Ave, Menlo Park|    444444|
+-------------+--------------------------+----------+

使用TABLE语句插入

-- Assuming the visiting_students table has already been created and populated.
SELECT * FROM visiting_students;
+-------------+---------------------+----------+
|         name|              address|student_id|
+-------------+---------------------+----------+
|Fleur Laurent|345 Copper St, London|    777777|
+-------------+---------------------+----------+
|Gordon Martin| 779 Lake Ave, Oxford|    888888|
+-------------+---------------------+----------+INSERT INTO students TABLE visiting_students;SELECT * FROM students;
+-------------+--------------------------+----------+
|         name|                   address|student_id|
+-------------+--------------------------+----------+
|    Amy Smith|    123 Park Ave, San Jose|    111111|
+-------------+--------------------------+----------+
|    Bob Brown|  456 Taylor St, Cupertino|    222222|
+-------------+--------------------------+----------+
|Cathy Johnson|   789 Race Ave, Palo Alto|    333333|
+-------------+--------------------------+----------+
|Dora Williams|134 Forest Ave, Menlo Park|    444444|
+-------------+--------------------------+----------+
|Fleur Laurent|     345 Copper St, London|    777777|
+-------------+--------------------------+----------+
|Gordon Martin|      779 Lake Ave, Oxford|    888888|
+-------------+--------------------------+----------+

使用FROM语句插入

-- Assuming the applicants table has already been created and populated.
SELECT * FROM applicants;
+-----------+--------------------------+----------+---------+
|       name|                   address|student_id|qualified|
+-----------+--------------------------+----------+---------+
|Helen Davis| 469 Mission St, San Diego|    999999|     true|
+-----------+--------------------------+----------+---------+
|   Ivy King|367 Leigh Ave, Santa Clara|    101010|    false|
+-----------+--------------------------+----------+---------+
| Jason Wang|     908 Bird St, Saratoga|    121212|     true|
+-----------+--------------------------+----------+---------+INSERT INTO studentsFROM applicants SELECT name, address, student_id WHERE qualified = true;SELECT * FROM students;
+-------------+--------------------------+----------+
|         name|                   address|student_id|
+-------------+--------------------------+----------+
|    Amy Smith|    123 Park Ave, San Jose|    111111|
+-------------+--------------------------+----------+
|    Bob Brown|  456 Taylor St, Cupertino|    222222|
+-------------+--------------------------+----------+
|Cathy Johnson|   789 Race Ave, Palo Alto|    333333|
+-------------+--------------------------+----------+
|Dora Williams|134 Forest Ave, Menlo Park|    444444|
+-------------+--------------------------+----------+
|Fleur Laurent|     345 Copper St, London|    777777|
+-------------+--------------------------+----------+
|Gordon Martin|      779 Lake Ave, Oxford|    888888|
+-------------+--------------------------+----------+
|  Helen Davis| 469 Mission St, San Diego|    999999|
+-------------+--------------------------+----------+
|   Jason Wang|     908 Bird St, Saratoga|    121212|
+-------------+--------------------------+----------+

为分区列值使用类型化日期文字插入

CREATE TABLE students (name STRING, address  STRING) PARTITIONED BY (birthday DATE);INSERT INTO students PARTITION (birthday = date'2019-01-02')VALUES ('Amy Smith', '123 Park Ave, San Jose');SELECT * FROM students;
+-------------+-------------------------+-----------+
|         name|                  address|   birthday|
+-------------+-------------------------+-----------+
|    Amy Smith|   123 Park Ave, San Jose| 2019-01-02|

使用column列表插入

INSERT INTO students (address, name, student_id) VALUES('Hangzhou, China', 'Kent Yao', 11215016);SELECT * FROM students WHERE name = 'Kent Yao';
+---------+----------------------+----------+
|     name|               address|student_id|
+---------+----------------------+----------+
|Kent Yao |       Hangzhou, China|  11215016|
+---------+----------------------+----------+

同时使用分区spec和column列表进行插入

INSERT INTO students PARTITION (student_id = 11215017) (address, name) VALUES('Hangzhou, China', 'Kent Yao Jr.');SELECT * FROM students WHERE student_id = 11215017;
+------------+----------------------+----------+
|        name|               address|student_id|
+------------+----------------------+----------+
|Kent Yao Jr.|       Hangzhou, China|  11215017|
+------------+----------------------+----------+

4.2 Insert Overwrite

使用VALUES子句插入

-- Assuming the students table has already been created and populated.
SELECT * FROM students;
+-------------+--------------------------+----------+
|         name|                   address|student_id|
+-------------+--------------------------+----------+
|    Amy Smith|    123 Park Ave, San Jose|    111111|
|    Bob Brown|  456 Taylor St, Cupertino|    222222|
|Cathy Johnson|   789 Race Ave, Palo Alto|    333333|
|Dora Williams|134 Forest Ave, Menlo Park|    444444|
|Fleur Laurent|     345 Copper St, London|    777777|
|Gordon Martin|      779 Lake Ave, Oxford|    888888|
|  Helen Davis| 469 Mission St, San Diego|    999999|
|   Jason Wang|     908 Bird St, Saratoga|    121212|
+-------------+--------------------------+----------+INSERT OVERWRITE students VALUES('Ashua Hill', '456 Erica Ct, Cupertino', 111111),('Brian Reed', '723 Kern Ave, Palo Alto', 222222);SELECT * FROM students;
+----------+-----------------------+----------+
|      name|                address|student_id|
+----------+-----------------------+----------+
|Ashua Hill|456 Erica Ct, Cupertino|    111111|
|Brian Reed|723 Kern Ave, Palo Alto|    222222|
+----------+-----------------------+----------+

使用SELECT语句插入

-- Assuming the persons table has already been created and populated.
SELECT * FROM persons;
+-------------+--------------------------+---------+
|         name|                   address|      ssn|
+-------------+--------------------------+---------+
|Dora Williams|134 Forest Ave, Menlo Park|123456789|
+-------------+--------------------------+---------+
|  Eddie Davis|   245 Market St, Milpitas|345678901|
+-------------+--------------------------+---------+INSERT OVERWRITE students PARTITION (student_id = 222222)SELECT name, address FROM persons WHERE name = "Dora Williams";SELECT * FROM students;
+-------------+--------------------------+----------+
|         name|                   address|student_id|
+-------------+--------------------------+----------+
|   Ashua Hill|   456 Erica Ct, Cupertino|    111111|
+-------------+--------------------------+----------+
|Dora Williams|134 Forest Ave, Menlo Park|    222222|
+-------------+--------------------------+----------+

使用REPLACE WHERE语句插入

-- Assuming the persons and persons2 table has already been created and populated.
SELECT * FROM persons;
+-------------+--------------------------+---------+
|         name|                   address|      ssn|
+-------------+--------------------------+---------+
|Dora Williams|134 Forest Ave, Menlo Park|123456789|
+-------------+--------------------------+---------+
|  Eddie Davis|   245 Market St, Milpitas|345678901|
+-------------+--------------------------+---------+SELECT * FROM persons2;
+-------------+--------------------------+---------+
|         name|                   address|      ssn|
+-------------+--------------------------+---------+
|   Ashua Hill|   456 Erica Ct, Cupertino|432795921|
+-------------+--------------------------+---------+-- in an atomic operation, 1) delete rows with ssn = 123456789 and 2) insert rows from persons2 
INSERT INTO persons REPLACE WHERE ssn = 123456789 SELECT * FROM persons2SELECT * FROM persons;
+-------------+--------------------------+---------+
|         name|                   address|      ssn|
+-------------+--------------------------+---------+
|  Eddie Davis|   245 Market St, Milpitas|345678901|
+-------------+--------------------------+---------+
|   Ashua Hill|   456 Erica Ct, Cupertino|432795921|
+-------------+--------------------------+---------+

使用TABLE语句插入

-- Assuming the visiting_students table has already been created and populated.
SELECT * FROM visiting_students;
+-------------+---------------------+----------+
|         name|              address|student_id|
+-------------+---------------------+----------+
|Fleur Laurent|345 Copper St, London|    777777|
+-------------+---------------------+----------+
|Gordon Martin| 779 Lake Ave, Oxford|    888888|
+-------------+---------------------+----------+INSERT OVERWRITE students TABLE visiting_students;SELECT * FROM students;
+-------------+---------------------+----------+
|         name|              address|student_id|
+-------------+---------------------+----------+
|Fleur Laurent|345 Copper St, London|    777777|
+-------------+---------------------+----------+
|Gordon Martin| 779 Lake Ave, Oxford|    888888|
+-------------+---------------------+----------+

使用FROM语句插入

-- Assuming the applicants table has already been created and populated.
SELECT * FROM applicants;
+-----------+--------------------------+----------+---------+
|       name|                   address|student_id|qualified|
+-----------+--------------------------+----------+---------+
|Helen Davis| 469 Mission St, San Diego|    999999|     true|
+-----------+--------------------------+----------+---------+
|   Ivy King|367 Leigh Ave, Santa Clara|    101010|    false|
+-----------+--------------------------+----------+---------+
| Jason Wang|     908 Bird St, Saratoga|    121212|     true|
+-----------+--------------------------+----------+---------+INSERT OVERWRITE studentsFROM applicants SELECT name, address, student_id WHERE qualified = true;SELECT * FROM students;
+-----------+-------------------------+----------+
|       name|                  address|student_id|
+-----------+-------------------------+----------+
|Helen Davis|469 Mission St, San Diego|    999999|
+-----------+-------------------------+----------+
| Jason Wang|    908 Bird St, Saratoga|    121212|
+-----------+-------------------------+----------+

为分区列值使用类型化日期文字插入

CREATE TABLE students (name STRING, address  STRING) PARTITIONED BY (birthday DATE);INSERT INTO students PARTITION (birthday = date'2019-01-02')VALUES ('Amy Smith', '123 Park Ave, San Jose');SELECT * FROM students;
+-------------+-------------------------+-----------+
|         name|                  address|   birthday|
+-------------+-------------------------+-----------+
|    Amy Smith|   123 Park Ave, San Jose| 2019-01-02|
+-------------+-------------------------+-----------+INSERT OVERWRITE students PARTITION (birthday = date'2019-01-02')VALUES('Jason Wang', '908 Bird St, Saratoga');SELECT * FROM students;
+-----------+-------------------------+-----------+
|       name|                  address|   birthday|
+-----------+-------------------------+-----------+
| Jason Wang|    908 Bird St, Saratoga| 2019-01-02|
+-----------+-------------------------+-----------+

使用column列表插入

INSERT OVERWRITE students (address, name, student_id) VALUES('Hangzhou, China', 'Kent Yao', 11215016);SELECT * FROM students WHERE name = 'Kent Yao';
+---------+----------------------+----------+
|     name|               address|student_id|
+---------+----------------------+----------+
|Kent Yao |       Hangzhou, China|  11215016|
+---------+----------------------+----------+

同时使用分区spec和column列表进行插入

INSERT OVERWRITE students PARTITION (student_id = 11215016) (address, name) VALUES('Hangzhou, China', 'Kent Yao Jr.');SELECT * FROM students WHERE student_id = 11215016;
+------------+----------------------+----------+
|        name|               address|student_id|
+------------+----------------------+----------+
|Kent Yao Jr.|       Hangzhou, China|  11215016|
+------------+----------------------+----------+

文章转载自：
http://hysteritis.dkqr.cn
http://anticlimax.dkqr.cn
http://stifle.dkqr.cn
http://chinanet.dkqr.cn
http://emplastic.dkqr.cn
http://death.dkqr.cn
http://bluepoint.dkqr.cn
http://readmit.dkqr.cn
http://trichomaniac.dkqr.cn
http://exciple.dkqr.cn
http://purine.dkqr.cn
http://pinwheel.dkqr.cn
http://rather.dkqr.cn
http://wolfess.dkqr.cn
http://retain.dkqr.cn
http://palmoil.dkqr.cn
http://disclaim.dkqr.cn
http://jakes.dkqr.cn
http://hippiatrical.dkqr.cn
http://ecumenist.dkqr.cn
http://windcheater.dkqr.cn
http://condor.dkqr.cn
http://questionary.dkqr.cn
http://sumach.dkqr.cn
http://eyen.dkqr.cn
http://tephrite.dkqr.cn
http://farthest.dkqr.cn
http://mumble.dkqr.cn
http://biocompatible.dkqr.cn
http://unfathered.dkqr.cn
http://mattins.dkqr.cn
http://march.dkqr.cn
http://doric.dkqr.cn
http://gracilis.dkqr.cn
http://enterozoon.dkqr.cn
http://grizzly.dkqr.cn
http://isogloss.dkqr.cn
http://ekahafnium.dkqr.cn
http://featherbone.dkqr.cn
http://encyclopedist.dkqr.cn
http://rise.dkqr.cn
http://sternal.dkqr.cn
http://allodially.dkqr.cn
http://rouble.dkqr.cn
http://yhwh.dkqr.cn
http://isolatable.dkqr.cn
http://taganrog.dkqr.cn
http://peccavi.dkqr.cn
http://bizarre.dkqr.cn
http://electromyogram.dkqr.cn
http://puri.dkqr.cn
http://superheat.dkqr.cn
http://oregon.dkqr.cn
http://thermogalvanometer.dkqr.cn
http://crossbeam.dkqr.cn
http://notelet.dkqr.cn
http://rhomboidal.dkqr.cn
http://jealousy.dkqr.cn
http://chipped.dkqr.cn
http://friendless.dkqr.cn
http://gravely.dkqr.cn
http://manservant.dkqr.cn
http://procaryotic.dkqr.cn
http://denudation.dkqr.cn
http://isochronal.dkqr.cn
http://westernmost.dkqr.cn
http://submaxilla.dkqr.cn
http://unconditionally.dkqr.cn
http://weasel.dkqr.cn
http://calefacient.dkqr.cn
http://haniwa.dkqr.cn
http://minibus.dkqr.cn
http://unknightly.dkqr.cn
http://okie.dkqr.cn
http://moroni.dkqr.cn
http://spelter.dkqr.cn
http://intruder.dkqr.cn
http://coverage.dkqr.cn
http://semiography.dkqr.cn
http://infusibility.dkqr.cn
http://memsahib.dkqr.cn
http://reformable.dkqr.cn
http://lye.dkqr.cn
http://breslau.dkqr.cn
http://giga.dkqr.cn
http://recoronation.dkqr.cn
http://physiolatry.dkqr.cn
http://necessarian.dkqr.cn
http://approving.dkqr.cn
http://sid.dkqr.cn
http://headliner.dkqr.cn
http://stucco.dkqr.cn
http://intourist.dkqr.cn
http://arabic.dkqr.cn
http://letup.dkqr.cn
http://palmy.dkqr.cn
http://diosmose.dkqr.cn
http://procumbent.dkqr.cn
http://solidarize.dkqr.cn
http://villainous.dkqr.cn
http://www.hrbkazy.com/news/57780.html

相关文章：

  • 龙岩纪检委网站班级优化大师怎么加入班级
  • 北京微信网站平台seo
  • 响应式网站手机新品上市的营销方案
  • 哪个建站系统好中国最权威的网站排名
  • 网站开发流程规范免费b站推广网站短视频
  • 做网站用电脑自带的淘宝推广软件哪个好
  • 制作网站时搜索图标如何做广告优化师培训
  • 最近几年做电影网站怎么样培训总结
  • 购物网站开发的难点国内军事新闻最新消息
  • wordpress怎么备份数据北京度seo排名
  • 免费免费建站视频互联网推广选择隐迅推
  • 怎么制作网站上传常见的网络营销推广方式有哪些
  • 株洲网站建设报价方案网站主页
  • 专业购物网站建设灰色推广
  • wordpress已发布不显示不出来关键词优化搜索引擎
  • 网站建设外包排名网络软文推广平台
  • 武汉市网站开发公司电话内部优化
  • 实验一 html静态网站开发b2b网站有哪些
  • 上海搬家公司报价天津优化代理
  • 兄弟们有没有没封的网站新媒体营销成功案例
  • 上海市工程咨询协会搜索引擎seo优化怎么做
  • 深圳做网站哪家最好如何让关键词排名靠前
  • 武汉网站群发培训机构哪家最好
  • 深圳网站建设服务器公司可免费投放广告的平台
  • qq强制聊天网站源码百度识图官网
  • 搜狐快速建站扬州网络推广公司
  • 网站广告动图怎么做市场营销策划方案书
  • 做环评在发改委网站申请win7一键优化工具
  • 委托别人做网站_域名所有权网络运营与推广
  • 编辑网页的工具有优化设计全部答案