Forum Discussion

annjoseph's avatar
annjoseph
Regular Visitor
6 years ago
Solved

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.

 

 

2 Replies