Skip to Content
avatar image
-1
Former Member

Is it possible to create indexes on Virtual Tables in SAP HANA?

We would like to load data from Hadoop into HANA using SDA and create virtual tables. Is it possible to create indexes on top of it?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 18, 2016 at 10:27 AM

    Hi Pavitra

    SAP Community is a professional's community and it is expected, that you do your share of research into the question before posting a question. Please make sure to use the documentation the next time and to include your research into your question posting.

    Usually I would have moderated this whole thread away, but as there had been multiple mistakes with this one, it may serve as an example for how not to post questions/answers.

    Cheers, Lars (Moderator)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 17, 2016 at 09:38 AM
    -1

    Hello Pavitra,

    I get the error "SAP DBTech JDBC: [7]: feature not supported: cannot create index on virtual table ", so it looks to be a feature request, which you can post here.

    Best regards,
    Hakan

    Add comment
    10|10000 characters needed characters exceeded

    • Hmm... interesting answer.

      One thing is, that it appears you used the _comment_ function instead of and _answer_, so the OP cannot accept it.

      I fixed this now and also changed the "answer" of the OP to a comment to your initial answer.

      The other thing is the content itself. What makes you think that a not supported feature is something that should be a feature request? Virtual tables are essentially views to other DBs tables. Indexes are data storage structures that are linked to other data storage structures (e.g. tables) but not to views.

      So, indexes for virtual tables are not something that is just missing - they are not possible.