hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
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.URI

Re: hive 2.1.0 + drop view

2016-08-26 Thread Gopal Vijayaraghavan
> NULL::character%20varying) ... > i want to say this is somehow related to a java version (we're using 8) >but i'm not sure. The "character varying" looks like a lot like a Postgres issue to me (though character varying could be the real term for varchar in another DB). The hive-metastore.log sh

Re: hive 2.1.0 + drop view

2016-08-26 Thread Mich Talebzadeh
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 S

Re: hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
thanks Gopal. you're right our metastore is using Postgres. very interesting you were able to intuit that! lemme give your suggestions a try and i'll post back. thanks! Stephen On Fri, Aug 26, 2016 at 8:32 AM, Gopal Vijayaraghavan wrote: > > NULL::character%20varying) > ... > > i want to say

Re: hive 2.1.0 + drop view

2016-08-26 Thread Mich Talebzadeh
Sounds like there are a number of issues with Hive metastore on Postgres. There have been a number of reports on this. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
well that doesn't bode well. :( we definitely need to use a remote metastore given this is a prod env with 100's of users. i wasn't able to see anything in the metastore log though so i'm wondering what logger to run to get that? don't think its hive.root.logger. thanks, Stephen. just togglin

Re: hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
yeah... so after the hive upgrade scripts ran we have this in pg for table "TABLS" {quote} dwr_prod_2_1_0=> \d "TBLS" Table "public.TBLS" Column | Type |Modifiers ++

Re: hive 2.1.0 + drop view

2016-08-26 Thread Mich Talebzadeh
You don't really want to mess around with the schema. This is what I have in Oracle 12c schema for TBLS. The same as yours [image: Inline images 1] But this is Oracle, a serious database :) HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6

Re: hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
thanks. what i gotta try is altering the table and changing "character varying(767)" to "varchar(767)" - I think. On Fri, Aug 26, 2016 at 12:59 PM, Mich Talebzadeh wrote: > You don't really want to mess around with the schema. > > This is what I have in Oracle 12c schema for TBLS. The same as y

Re: hive 2.1.0 + drop view

2016-08-26 Thread Mich Talebzadeh
Actually I don't understand why they have defined TBL_NAME and TBL_TYPE as NVARCHAR (this is from Sybase similar to yours) [image: Inline images 1] Oracle seems to be correct. And if we look further Use the fixed-length datatype, *nchar(n)* , and the variable-length datatype, *nvarchar(n)*, for

Re: hive 2.1.0 + drop view

2016-08-26 Thread Ashutosh Chauhan
Its a bug in DataNucleus. See discussion on : https://issues.apache.org/jira/browse/HIVE-14322 On Fri, Aug 26, 2016 at 1:34 PM, Mich Talebzadeh wrote: > Actually I don't understand why they have defined TBL_NAME and TBL_TYPE as > NVARCHAR (this is from Sybase similar to yours) > > [image: Inline

Re: hive 2.1.0 + drop view

2016-08-26 Thread Stephen Sprague
just to cap this discussion... thank you Ashutosh for that link that was very helpful. I did the following based on my reading of it. 1. added the following to hive-site.xml datanucleus.rdbms.initializeColumnInfo NONE this allows one to create views and drop views however it does not a

Re: hive 2.1.0 + drop view

2016-08-29 Thread Sergey Shelukhin
en Sprague mailto:sprag...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, August 26, 2016 at 21:08 To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org&g