Read data from above file into dataframes (df1 and df2). Display number of partitions in df1. Create a new dataframe df3 from df1, along with a new column salary, and keep it constant 1000 append df2 ...
Help you efficiently and focus on Spark SQL(v4.0.0) & Hive(v3.x) development. support Spark & Hive SQL error grammar check, spark sql semantic check, syntax ...