write back to hive table

[annjoseph]

Hi All,

I was trying to write back to hive table using native query function in query editor.But I am getting an error at the Native query step.

Expression.Error: Native queries aren't supported by this value.
Details:
[Table]

M query:

let Source = Impala.Database("xxx.abc.com:11111"),
Schema = Source{[Name="sc",Kind="Schema"]}[Data],
write_back_tst_Table = Schema{[Name="write_back_tst1",Kind="Table"]}[Data],

INSERT=Value.NativeQuery(write_back_tst_Table,"write_back_tst")
in
INSERT

**write_back_tst has the sql query added as a custom column

Can somebody suggest methods to resolve the error.

Thank you.

[Anonymous]

Hello

do we have a HIVE connector in Power Apps? 

I have a use case where I want to pull data from Azure HDInsight table in Power Apps and also write from Power Apps to the same HIVE table.

[amitchandak · Accepted solution]

@annjoseph , I doubt write back. refer this:https://blog.crossjoin.co.uk/2018/10/07/power-query-write-data/

But if you can wite back using the power app. You can add power app to power bi

example: https://www.youtube.com/watch?v=LxuRzj0X348