0: jdbc:mysql://hdp1.demo.lab/hive> set mapred.job.queue.name=root.admin; Error: Unknown system variable 'job' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> set tez.queue.name=root.admin; Error: Unknown system variable 'queue' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=root.admin; Error: Unknown system variable 'queue' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> SET TEZ.QUEUE.NAME=ROOT.ADMIN 0: jdbc:mysql://hdp1.demo.lab/hive> SET TEZ.QUEUE.NAME=ROOT.ADMIN; Error: Unknown system variable 'QUEUE' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> set TEZ.queue.name=root.admin; Error: Unknown system variable 'queue' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=ROOT.ADMIN; Error: Unknown system variable 'queue' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.queue.name=admin; Error: Unknown system variable 'queue' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> SET tez.job.queue.name=admin; Error: Unknown system variable 'job' (state=HY000,code=1193) 0: jdbc:mysql://hdp1.demo.lab/hive> ... View more

Assign to @Jonathan Sneep, You can also create a new temp table with JSON file format and use "insert into json table form existing table;" Post creating the new table, the files can be read form hdfs in json format. ... View more

workflow-log.txt@Sivaprasanna I am use informatica BDM 10.0.1 version. Source is mysql and target is HIVE table. While executing the Infoematica workflow iam getting the error as mentioned. FYR I am attaching the workflow log. Thanks. ... View more

Any solution on this? ... View more

@kotesh banoth Can you try without SASL, or somehow it need to be imported in your python. Pleas try this with NOSASL to see what you get next: (or verify if the "cyrus-sasl-devel" is installed properly) conn = hive.connect(host='172.16.0.XXX', port=10000, username='kotesh', auth='NOSASL') . It will need to following config on your hive side. <property> <name>hive.server2.authentication</name> <value>NOSASL</value> </property> . ... View more

Thanks so much, steps followed: 1) psql ambari -U ambari -W -p 5432 2) pg_dump ambari -U ambari -W -p 5432 > ambari_bkup 3) Delete commands 4) ambari-server start ... View more

Hello Kotesh, Were you able to resolve this issue after setting all the properties as suggested? ... View more

@rguruvannagari thanks a lot. ... View more

The query fails here. Below is the stack for the error generated public static RecordUpdater getAcidRecordUpdater(JobConf jc, TableDesc tableInfo, int bucket, FileSinkDesc conf, Path outPath, ObjectInspector inspector, Reporter reporter, int rowIdColNum) throws HiveException, IOException { HiveOutputFormat<?, ?> hiveOutputFormat = getHiveOutputFormat(jc, tableInfo); AcidOutputFormat<?, ?> acidOutputFormat = null; if (hiveOutputFormat instanceof AcidOutputFormat) { acidOutputFormat = (AcidOutputFormat)hiveOutputFormat; } else { throw new HiveException("Unable to create RecordUpdater for HiveOutputFormat that does not " + "implement AcidOutputFormat"); Are these tables have ACID support enabled ? ... View more