Home Forums Hortonworks Sandbox Hive Indexing

This topic contains 1 reply, has 1 voice, and was last updated by  Conor Gelvin 5 months, 3 weeks ago.

  • Creator
  • #56692

    Conor Gelvin

    Whenever I try to build a table with an index, it gives me an error about not being able to contstruct a path from a null string. This is only after being forced to defer the rebuild because it errors and says I didn’t defer the rebuild.

    Also, I’m not being permitted to delete the empty tables that I cannot rebuild because they are indexed. I’m told it might be because of a dependency between the table and the index where I have to delete the index itself first… in which case, how do I go about doing that?

    Thanks in advance

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
  • #56694

    Conor Gelvin

    So I’ve tried dropping the index before dropping the indexed table using the line:

    drop index if exists <index> on table <table>;

    But now it reports an error of not knowing what to do with <table>, and so i remove it and no error is reported, but it doesn’t remove anything, which makes sense because it doesn’t know where to remove anything from. What is going on here?

Viewing 1 replies (of 1 total)