You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Amjad ALSHABANI <as...@gmail.com> on 2015/06/18 17:29:55 UTC
Can not Drop Table/View in Hive
Hello All,
I m having an issue when trying to droping a table (or a view) in hive:
I m using Hive0.14, metastore MySql, hadoop 2.4, HDP 2.2.4
when issuing the following command:
$ hive -e "use poc_pdd; show tables;"
it hangs...
when activating the DEBUG (just getting hte last lines from the output):
$ hive -hiveconf hive.root.logger=DEBUG,console -e "use poc_pdd; show
tables;"
...
...
15/06/18 16:02:16 [Thread-0]: DEBUG ipc.ProtobufRpcEngine: Call:
getFileInfo took 1ms
15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: stopping client from cache:
org.apache.hadoop.ipc.Client@5e08da92
15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: removing client from cache:
org.apache.hadoop.ipc.Client@5e08da92
15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: stopping actual client
because no more references remain: org.apache.hadoop.ipc.Client@5e08da92
15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: Stopping client
15/06/18 16:02:16 [IPC Client (1483655295) connection to Myhadoop-server/
10.101.148.214:57001 from hadoop]: DEBUG ipc.Client: IPC Client
(1483655295) connection to Myhadoop-server/10.101.148.214:57001 from
hadoop: closed
15/06/18 16:02:16 [IPC Client (1483655295) connection to Myhadoop-server/
10.101.148.214:57001 from hadoop]: DEBUG ipc.Client: IPC Client
(1483655295) connection to Myhadoop-server/10.101.148.214:57001 from
hadoop: stoppe
Any Ideas why i m having this Isuue ??
Amjad
Re: Can not Drop Table/View in Hive
Posted by Amjad ALSHABANI <as...@gmail.com>.
Hello,
Just for the record:
I ve got my issue resolved.
by adding to my hive-site.xml the property:
<property>
<name>datanucleus.fixedDatastore</name>
<value>true</value>
</property>
But still do not understand how does that impact the metastore :(
Amajd
On Thu, Jun 18, 2015 at 5:29 PM, Amjad ALSHABANI <as...@gmail.com>
wrote:
> Hello All,
>
> I m having an issue when trying to droping a table (or a view) in hive:
> I m using Hive0.14, metastore MySql, hadoop 2.4, HDP 2.2.4
>
> when issuing the following command:
>
> $ hive -e "use poc_pdd; show tables;"
>
> it hangs...
>
> when activating the DEBUG (just getting hte last lines from the output):
>
> $ hive -hiveconf hive.root.logger=DEBUG,console -e "use poc_pdd; show
> tables;"
> ...
> ...
> 15/06/18 16:02:16 [Thread-0]: DEBUG ipc.ProtobufRpcEngine: Call:
> getFileInfo took 1ms
> 15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: stopping client from
> cache: org.apache.hadoop.ipc.Client@5e08da92
> 15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: removing client from
> cache: org.apache.hadoop.ipc.Client@5e08da92
> 15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: stopping actual client
> because no more references remain: org.apache.hadoop.ipc.Client@5e08da92
> 15/06/18 16:02:16 [Thread-0]: DEBUG ipc.Client: Stopping client
> 15/06/18 16:02:16 [IPC Client (1483655295) connection to Myhadoop-server/
> 10.101.148.214:57001 from hadoop]: DEBUG ipc.Client: IPC Client
> (1483655295) connection to Myhadoop-server/10.101.148.214:57001 from
> hadoop: closed
> 15/06/18 16:02:16 [IPC Client (1483655295) connection to Myhadoop-server/
> 10.101.148.214:57001 from hadoop]: DEBUG ipc.Client: IPC Client
> (1483655295) connection to Myhadoop-server/10.101.148.214:57001 from
> hadoop: stoppe
>
>
>
> Any Ideas why i m having this Isuue ??
>
>
>
> Amjad
>
>