@jingyong zou, Is it a new table or an older table created in HDP2.x? if it is the older table created in HDP2.x than there might be chances you are hitting HIVE-20593 ... View more

@Rodrigo Gallacci Can you please provide information regarding which HDP and hive version you are using? Its seems like a managed table, are you getting any error logs? if its hdp3.1 can you usine beeline in debug more like below beeline --verbose=true and post the logs ? ... View more

@Mahendta Chouhan , I can see the error Caused by: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: GSS initiate failed The error above likely suggests your HMS is configured for security (kerberos) but that your login lacks a valid TGT (such as one obtained via kinit). Could you post the output of klist, and confirm if a 'hadoop fs' test Also check the if you are logged in with correct user, which have all the access. ... View more

Hi @Kunal Agarwal Can you check if below property is enable of not ? You can login to Ambari and go to YARN Configs page. Search yarn.resourcemanager.webapp.ui-actions.enabled If it exists, change the value to True. If it does not exist, clear the filter and add it from ‘Custom yarn-site’ then ‘Add Property’ and set the value to true. Save and restart. ... View more

hi @Anurag Mishra, for memeory : https://hortonworks.com/blog/how-to-plan-and-configure-yarn-in-hdp-2-0/ did you tried in uber mode ? <code>mapreduce.job.ubertask.enable = true ... View more

Hi @vgarg, Since 0.11 hive has a NVL function nvl(T value, T default_value) which says Returns default value if value is null else returns value ... View more

Hi @Abhijeet Rajput, Did you tried like this ? dfOrders.write.mode("overwrite").format("jdbc") .option("driver", "com.microsoft.sqlserver.jdbc.SQLServerDriver") .option("url", "jdbc:sqlserver://server.westus.cloudapp.azure.com;databaseName=TestDB") .option("dbtable", "TestDB.dbo.orders") .option("user", "myuser") .option("batchsize","200000") .option("password","MyComplexPassword!001").save() Thanks Vikas Srivastava ... View more

@Redhouane Abdellaoui Can you please if the inode are available ? You can check this with "df -i" Thanks Vikas Srivastava ... View more

Hi @PJ Which you have said like it didnt launched the containers till 8:55 which means its not getting the proper resource to start the process and as there are already jobs running in the same queue support the issue as well. try decreasing the value to 0.1 . ... View more

@PJ did you try to explain extended $cmd? if possible repair it once like msck repair table. ... View more