Forum Discussion
write back to hive table
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.
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
2 Replies
- amitchandakSuper User
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
- AnonymousNot applicable
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.