Member since
05-31-2022
1
Post
0
Kudos Received
0
Solutions
09-16-2023
08:51 AM
Hi, You need to set in hive-site.xml, these three tags to get this working with hive: <property>
<name>google.cloud.auth.service.account.json.keyfile</name>
<value>/home/hadoop/keyfile.json</value>
</property>
<property>
<name>fs.gs.reported.permissions</name>
<value>777</value>
</property>
<property>
<name>fs.gs.path.encoding</name>
<value>/home/hadoop/</value>
</property> Same xml tags we can have it on hadoop in core-site.xml to have it working with hdfs, On beeline, just execute this and it shall work: INSERT OVERWRITE DIRECTORY 'gs://bucket/table' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' SELECT * FROM table; Please upvote if you found helpful!
... View more