alter table schema_7539.activityparameters_4ITEM_1 COMPACT 'MAJOR'; in hive then re run query. If that does't work run query in spark hive context. ... View more

Hi @Dmitro Vasilenko, did u get a chance to look this. @nifi @ExecuteSparkInteractive @spark @Timothy Spann spark.sql("insert into dbname.tablename values('from livy')") is not working spark.sql("insert into dbname.tablename select * from dbname.tablename") is working For more information, please look into my previous posts on same page/tasl/requiement. @nifi @executesparkintactive ... View more

Hi, I am trying to execute the below statements as part of code values in processor : import org.apache.spark.sql.hive.HiveContext val hiveContext = new HiveContext(sc) import hiveContext._ hiveContext.sql("insert into cpv.del values('from livy')") After looking recent comments from @Dmitro Vasilenko @, I have changed code to spark.sql("insert into dbname.tablename values('from livy')") Still Getting bad request error. Please look into attachements for configuration parameters. tempsnip.png tempsnipn.png Looking for quick response, Thanks ... View more

Hi , Any solution for this. I am also facing same issue. ... View more

Is this worked ? ... View more

alter table <<table_name>> compact 'MAJOR'; Hi, Is this way worked for any one ? If worked for you, can you help me out in for what table we need to this compact action. In may case I have a master table mt1 and lookup tables t2,t3,t4,t5. And I am inserting this select result to target table t6. These all are orc type. Thanks Thirupathi Nerella ... View more