"There is a lengthy discussion, but it's unclear how to actually drop the darn table. In fact, that page"
Dumb work around: You could go directly to mysql and delete the table... Or make a serde with that name just so you will not get the class not found error :) On Wed, Jun 11, 2014 at 9:59 AM, Keith Wiley <kwi...@keithwiley.com> wrote: > That's beside the point. The question is, why can't I drop the table? > There is no excuse for not dropping a table just because some serde can't > be found. It shouldn't operate that way at all. > > Thanks. > > On Jun 10, 2014, at 23:33 , Nitin Pawar wrote: > > > if you have added a table with a serde definition > > > > then just keep the jar in local filesystem and then in hive console do > > add jar <full path to jar>; > > > > this should make your serde available to table and you should be able to > drop the table then. > > > > I just tried above steps and it works for my json based tables. > > > > > > On Wed, Jun 11, 2014 at 2:24 AM, Keith Wiley <kwi...@keithwiley.com> > wrote: > > I tried to create a table that would use a csv serde. There were > various problems with it, primarily in that I couldn't figure out how to > specify the path to the serde (whether I indicate the serde location either > locally or on HDFS) there were subsequent errors about not finding the > serde, even though the paths were correct). > > > > So I decided to drop the table since it wasn't working...but the serde > error that is causing these problems to begin with prevents me from > dropping the table due to a serde-doesn't-exist error. Yeah, duh, that's > the problem in the first place. > > > > This is an acknowledged problem, as indicated here: > > https://issues.apache.org/jira/browse/HIVE-3392 > > ...but I don't understand from that page how to get around the problem. > There is a lengthy discussion, but it's unclear how to actually drop the > darn table. In fact, that page suggests the problem is officially > classified as "won't be fixed". > > > > Note, this problem also prevents me from renaming the table via "alter". > > > > I don't know what to do at this point. Any ideas? > > > > > ________________________________________________________________________________ > > Keith Wiley kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > > > "The easy confidence with which I know another man's religion is folly > teaches > > me to suspect that my own is also." > > -- Mark Twain > > > ________________________________________________________________________________ > > > > > > > > > > -- > > Nitin Pawar > > > > ________________________________________________________________________________ > Keith Wiley kwi...@keithwiley.com keithwiley.com > music.keithwiley.com > > "It's a fine line between meticulous and obsessive-compulsive and a > slippery > rope between obsessive-compulsive and debilitatingly slow." > -- Keith Wiley > > ________________________________________________________________________________ > >
