Below is the code and output from function:- CREATE FUNCTION my_function() RETURNS STRING BEGIN DROP TABLE default.dg_join3 ; CREATE TABLE default.dg_join3 (name string, phone string) ; INSERT INTO TABLE default.dg_join3 SELECT a.name, b.phone from default.dg_1 a,default.dg_2 b where a.id = b.id ; SELECT * FROM default.dg_join3 ; END; -- Invoke the function PRINT 'world, come with me now'; PRINT my_function(); [root@sandbox hplsql-0.3.17]# ./hplsql -f my_function.txt
world, come with me now
16/06/28 09:34:15 INFO jdbc.Utils: Supplied authorities: localhost:10000
16/06/28 09:34:15 INFO jdbc.Utils: Resolved authority: localhost:10000
Open connection: jdbc:hive2://localhost:10000 (414 ms)
Starting SQL statement
SQL statement executed successfully (387 ms)
Starting SQL statement
SQL statement executed successfully (1.29 sec)
Starting SQL statement
SQL statement executed successfully (9.85 sec)
Starting query
Query executed successfully (880 ms)
null
... View more
