Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Solved
Go to solution
update beeswax_savedquery table in hue database
Labels:
- Labels:
-
Cloudera Hue
Expert Contributor
Created on 05-09-2017 09:11 AM - edited 09-16-2022 04:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi , I have a situation . is it ok if i update beeswax_savedquery table in hue database.
a user now have a new id ,so he wants all the saved queries in old id to moved to new id .
can i follow this approach .
CREATE TEMPORARY TABLE tmptable SELECT * FROM table WHERE primarykey = 1; UPDATE tmptable SET primarykey = 2 WHERE primarykey = 1; INSERT INTO table SELECT * FROM tmptable WHERE primarykey = 2;
1 ACCEPTED SOLUTION
Expert Contributor
Created 06-02-2017 01:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
In CDH 5.8, queries can be exported from a user's home directory and imported to another users in JSON format. Steps bellow
1. Go to "my documents" on old user. (house icon)
2. Select the queries you would like to export. If they're in a folder, you can export the whole folder or use "cntrl click" to select multiple queries. Another option is to drag select them.
3. Click the "download" icon on the action bar at the top of the file browser. This will download the queries as a json file or multiple json files.
4. Log into the new account and go to "my documents" house icon.
5. Click the "upload" icon in the action bar.
6. Select a json file in the file browser. json files can only be uploaded one at a time.
7. Click import to finish the process.
1 REPLY 1
Expert Contributor
Created 06-02-2017 01:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
In CDH 5.8, queries can be exported from a user's home directory and imported to another users in JSON format. Steps bellow
1. Go to "my documents" on old user. (house icon)
2. Select the queries you would like to export. If they're in a folder, you can export the whole folder or use "cntrl click" to select multiple queries. Another option is to drag select them.
3. Click the "download" icon on the action bar at the top of the file browser. This will download the queries as a json file or multiple json files.
4. Log into the new account and go to "my documents" house icon.
5. Click the "upload" icon in the action bar.
6. Select a json file in the file browser. json files can only be uploaded one at a time.
7. Click import to finish the process.