0

We are joining tables from hana and hive and a view creating query from Smart Data Access

EX: Select top 10 from hana.table join hive.table

Hana support TOP funtion but Hive doesnt. Is there any existing UDF present in Hive similar to TOP. I know in hive we have LIMIT but we required a UDF function which similar to hana?

Please suggest any workaround for this problem. Thanks in advance.

marjun
  • 696
  • 5
  • 17
  • 30

1 Answers1

0

You will have to use the LIMIT function

Ramachandran.A.G
  • 4,788
  • 1
  • 12
  • 24