Hive运行语句报错： Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Me

报错内容

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.hive.metastore.api.MetaException You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1)

解决办法

第一种，hql语句有问题(大多数是这个)

再检查一遍自己写的Hql语句。

第二种，yarn资源不足

调整hadoop配置文件yarn-site.xml中yarn.nodemanager.vmem-pmem-ratio的值：

<property>
   <name>yarn.scheduler.minimum-allocation-mb</name>
   <value>2048</value>
   <description>default value is 1024</description>
</property>

调整该参数，上述问题可得到解决。