hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: hive 2.1.0 + drop view
Date Fri, 26 Aug 2016 15:24:08 GMT
Hi

Don't see any issue in Spark 2 and java version "1.8.0_77"


hive> create view v_dummy2 as select * from dummy2;
OK
hive> select max(id) from v_dummy2;
Query ID = hduser_20160826154849_0dcba182-3a45-4cdf-96e6-ead452c4bca3
Starting Spark Job = efc38e16-bfdc-410f-a25f-b5fa8d306432
Query Hive on Spark job[2] stages:
Status: Running (Hive on Spark job[2])
Job Progress Format
CurrentTime StageId_StageAttemptId:
SucceededTasksCount(+RunningTasksCount-FailedTasksCount)/TotalTasksCount
[StageCost]
2016-08-26 16:19:31,595 Stage-4_0: 41/41 Finished       Stage-5_0: 1/1
Finished
Status: Finished successfully in 24.11 seconds
OK
3325000
hive> drop view v_dummy2;
OK

HTH


Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com


*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.



On 26 August 2016 at 16:09, Stephen Sprague <spragues@gmail.com> wrote:

> hey guys,
> this ones a little more strange.
>
> hive> create view foo_vw as select * from foo;
> OK
> Time taken: 0.376 seconds
>
> hive> drop view foo_vw;
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
> MetaException(message:java.lang.IllegalArgumentException:
> java.net.URISyntaxException: Relative path in absolute URI:
> NULL::character%20varying)
>
> i want to say this is somehow related to a java version (we're using 8)
> but i'm not sure.
>
> any insights on how to go from here?
>
> cheers,
> Stephen
>
> PS setting hive.root.logger=DEBUG,console here's the traceback.
>
> Caused by: MetaException(message:java.lang.IllegalArgumentException:
> java.net.URISyntaxException: Relative path in absolute URI:
> NULL::character%20varying)
>         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_
> table_with_environment_context_result$drop_table_with_environment_context_
> resultStandardScheme.read(ThriftHiveMetastore.java:47552)
>         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_
> table_with_environment_context_result$drop_table_with_environment_context_
> resultStandardScheme.read(ThriftHiveMetastore.java:47529)
>         at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$drop_
> table_with_environment_context_result.read(ThriftHiveMetastore.java:47471)
>         at org.apache.thrift.TServiceClient.receiveBase(
> TServiceClient.java:86)
>         at org.apache.hadoop.hive.metastore.api.
> ThriftHiveMetastore$Client.recv_drop_table_with_environment_context(
> ThriftHiveMetastore.java:1358)
>         at org.apache.hadoop.hive.metastore.api.
> ThriftHiveMetastore$Client.drop_table_with_environment_
> context(ThriftHiveMetastore.java:1342)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.
> drop_table_with_environment_context(HiveMetaStoreClient.java:2329)
>         at org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.
> drop_table_with_environment_context(SessionHiveMetaStoreClient.java:114)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.
> dropTable(HiveMetaStoreClient.java:1074)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.
> dropTable(HiveMetaStoreClient.java:1010)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:483)
>         at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.
> invoke(RetryingMetaStoreClient.java:154)
>         at com.sun.proxy.$Proxy21.dropTable(Unknown Source)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:483)
>         at org.apache.hadoop.hive.metastore.HiveMetaStoreClient$
> SynchronizedHandler.invoke(HiveMetaStoreClient.java:2254)
>         at com.sun.proxy.$Proxy21.dropTable(Unknown Source)
>         at org.apache.hadoop.hive.ql.metadata.Hive.dropTable(Hive.
> java:1172)
>
>
>

Mime
View raw message