About云-梭伦科技»专题 › 交流区 › 技术交流 › Hive › 启动hive报错，麻烦看看

启动hive报错，麻烦看看

查看数: 16898 | 评论数: 10 | 收藏 0

关灯 | 提示：支持键盘翻页<-左右->

帖子模式

小钟

发布时间: 2016-10-5 18:32

正文摘要:

如图，麻烦大神看看

小钟 发表于 2016-10-6 13:52:27

知道原因了，我把metastore的服务开启之后就可以了，谢谢各位大神了。

arsenduan 发表于 2016-10-6 13:32:57

本帖最后由 arsenduan 于 2016-10-6 13:38 编辑

小钟发表于 2016-10-6 09:18
16/10/05 17:18:58 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no l ...

在0.10  0.11或者之后的HIVE版本 hive.metastore.local 属性不再使用。看样只能注释掉或则为flase
对这个
<property>
  <name>hive.metastore.uris</name>
  <value>thrift://centos:9083</value>
</property>

centos他的ip是多少，哪台主机的，是否是192.168.75.11填对地址应该就没问题了

小钟 发表于 2016-10-6 09:18:38

tntzbzc 发表于 2016-10-6 09:14
楼主尝试下面配置：
将hive.metastore.local配为true

16/10/05 17:18:58 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.

将hive.metastore.local配为true ，配置，增加了这个错误。

其他依然报错，是不是mysql有问题？

小钟 发表于 2016-10-6 09:17:00

distributed under the License is distributed on an "AS IS" BASIS,
      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
         See the License for the specific language governing permissions and
            limitations under the License.
            -->
<configuration>







<property>
<name>hive.metastore.local</name>
  <value>true</value>
  </property>

<property>
<name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.75.11:3306/hive?createDatabaseIfNotExist=true</value>
  </property>

<property>
<name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
  </property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>

<property>
  <name>datanucleus.fixedDatastore</name>
<value>false</value>
</property>

<property>
  <name>hive.exec.scratchdir</name>
<value>/tmp/hive-${user.name}</value>
   <description>Scratch space for Hive jobs</description>
   </property>

<property>
  <name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
   <description>location of default database for the warehouse</description>
   </property>

   <property>
      <name>hive.metastore.uris</name>
      <value>thrift://127.0.0.1:9083</value>
      </property>

<property>
<name>hive.server2.logging.operation.log.location</name>
   <value>/user/hive/operation_logs</value>
         <description>Top level directory where operation logs are stored if logging functionality is enabled</description>
         </property>

</configuration>

tntzbzc 发表于 2016-10-6 09:14:00