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 <sprag...@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) > > >
