[SPARK-32388] TRANSFORM when schema less should keep same with hive

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: angerszhu
• Reporter: angerszhu
• Created: 22/Jul/20 08:47
• Updated: 12/Dec/22 18:11
• Resolved: 27/Oct/20 00:26

Description

Hive transform without schema

 

hive> create table t (c0 int, c1 int, c2 int);
hive> INSERT INTO t VALUES (1, 1, 1);
hive> INSERT INTO t VALUES (2, 2, 2);
hive> CREATE VIEW v AS SELECT TRANSFORM(c0, c1, c2) USING 'cat' FROM t;

hive> DESCRIBE v;
key                 	string              	                    
value               	string              	                    

hive> SELECT * FROM v;
1	1	1
2	2	2

hive> SELECT key FROM v;
1
2

hive> SELECT value FROM v;
1	1
2	2

Spark

hive> create table t (c0 int, c1 int, c2 int); 
hive> INSERT INTO t VALUES (1, 1, 1); 
hive> INSERT INTO t VALUES (2, 2, 2); 
hive> CREATE VIEW v AS SELECT TRANSFORM(c0, c1, c2) USING 'cat' FROM t; 

hive> SELECT * FROM v; 
1   11
2   22 

 

Issue Links

• links to: [Github] Pull Request #29421 (AngersZhuuuu)