jobit mathew created SPARK-29591:
------------------------------------
Summary: Support data insertion in a different order if you wish
or even omit some columns in spark sql also like postgresql
Key: SPARK-29591
URL: https://issues.apache.org/jira/browse/SPARK-29591
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 2.4.4
Reporter: jobit mathew
Support data insertion in a different order if you wish or even omit some
columns in spark sql also like postgre sql.
*In postgre sql*
CREATE TABLE weather (
city varchar(80),
temp_lo int, -- low temperature
temp_hi int, -- high temperature
prcp real, -- precipitation
date date
);
*You can list the columns in a different order if you wish or even omit some
columns,*
INSERT INTO weather (date, city, temp_hi, temp_lo)
VALUES ('1994-11-29', 'Hayward', 54, 37);
*But in spark sql i*s not allowing to insert data in different order or omit
any column.Better to support this as it can save time if we can not predict any
specific column value or if some value is fixed always.
create table jobit(id int,name string);
> insert into jobit values(1,"Ankit");
Time taken: 0.548 seconds
spark-sql> *insert into jobit (id) values(1);*
*Error in query:*
mismatched input 'id' expecting \{'(', 'SELECT', 'FROM', 'VALUES', 'TABLE',
'INSERT', 'MAP', 'REDUCE'}(line 1, pos 19)
== SQL ==
insert into jobit (id) values(1)
-------------------^^^
spark-sql> insert into jobit (name,id) values("Ankit",1);
Error in query:
mismatched input 'name' expecting \{'(', 'SELECT', 'FROM', 'VALUES', 'TABLE',
'INSERT', 'MAP', 'REDUCE'}(line 1, pos 19)
== SQL ==
insert into jobit (name,id) values("Ankit",1)
-------------------^^^
spark-sql>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
