index.html 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE html
  3. PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4. <html lang="en-us" xml:lang="en-us">
  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  7. <link rel="stylesheet" type="text/css" href="commonltr.css"/>
  8. <title>Beeswax</title>
  9. </head>
  10. <body id="topic_4"><a name="topic_4"><!-- --></a>
  11. <h1 class="title topictitle1">Beeswax </h1>
  12. <div class="body conbody">
  13. <p class="p">The Beeswax application enables you to perform queries on Apache Hive, a
  14. data warehousing system designed to work with Hadoop. For information about Hive, see <a class="xref" href="http://archive.cloudera.com/cdh4/cdh/4/hive/" target="_blank">Hive Documentation</a>. You can create Hive databases, tables and
  15. partitions, load data, create, run, and manage queries, and download the results in a
  16. Microsoft Office Excel worksheet file or a comma-separated values file. </p>
  17. </div>
  18. <div class="topic concept nested1" xml:lang="en-US" lang="en-US" id="topic_4_1"><a name="topic_4_1"><!-- --></a>
  19. <h2 class="title topictitle2">Beeswax and Hive Installation and
  20. Configuration </h2>
  21. <div class="body conbody">
  22. <p class="p">Beeswax is installed and configured as part of Hue. <span class="ph">For information about installing and configuring Hue,
  23. see Hue Installation in <a class="xref" href="http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/CDH4-Installation-Guide.html" target="_blank">http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/CDH4-Installation-Guide.html</a>.</span>
  24. </p>
  25. <p class="p">Beeswax assumes an existing Hive installation. The Hue installation
  26. instructions include the configuration necessary for Beeswax to access Hive. You can view
  27. the current Hive configuration from the <strong class="ph b">Settings</strong> tab in
  28. the Beeswax application. </p>
  29. <p class="p">By default, a Beeswax user can see the saved queries for all users –
  30. both his/her own queries and those of other Beeswax users. To restrict viewing saved queries
  31. to the query owner and Hue administrators, set the <samp class="ph codeph">share_saved_queries</samp> property under the <samp class="ph codeph">[beeswax]</samp> section in the Hue configuration file to <samp class="ph codeph">false</samp>. </p>
  32. </div>
  33. </div>
  34. <div class="topic concept nested1" xml:lang="en-US" lang="en-US" id="topic_4_2"><a name="topic_4_2"><!-- --></a>
  35. <h2 class="title topictitle2">Starting Beeswax </h2>
  36. <div class="body conbody">
  37. <p class="p">Click the <strong class="ph b">Beeswax</strong> icon (<img class="image" src="/static/art/help/icon_beeswax_24.png"/>)
  38. in the navigation bar at the top of the Hue browser page. </p>
  39. </div>
  40. </div>
  41. <div class="topic concept nested1" id="concept_xvg_nzh_dk"><a name="concept_xvg_nzh_dk"><!-- --></a>
  42. <h2 class="title topictitle2">Managing Databases, Tables, and Partitions</h2>
  43. <div class="body conbody">
  44. <p class="p" id="concept_xvg_nzh_dk__p_ygl_m13_dk"><a name="concept_xvg_nzh_dk__p_ygl_m13_dk"><!-- --></a>You can create databases, tables, partitions, and load data by executing
  45. <a class="xref" href="http://archive.cloudera.com/cdh4/cdh/4/hive/language_manual/data-manipulation-statements.html" target="_blank">Hive data manipulation
  46. statements</a> in the Beeswax application.</p>
  47. <p class="p" id="concept_xvg_nzh_dk__p_pdp_m13_dk"><a name="concept_xvg_nzh_dk__p_pdp_m13_dk"><!-- --></a>You can also use the <a class="xref" href="metastoremanager.html#xd_583c10bfdbd326ba-3ca24a24-13d80143249--7f9b">Metastore Manager</a> application to manage the
  48. databases, tables, and partitions and load data.</p>
  49. </div>
  50. </div>
  51. <div class="topic concept nested1" xml:lang="en-US" lang="en-US" id="topic_4_2_1"><a name="topic_4_2_1"><!-- --></a>
  52. <h2 class="title topictitle2">Installing Example Queries and
  53. Tables</h2>
  54. <div class="body conbody">
  55. <div class="note note" id="topic_4_2_1__note_sb1_dlk_2k"><a name="topic_4_2_1__note_sb1_dlk_2k"><!-- --></a><span class="notetitle"><img src="/static/art/help/note.jpg"/> 
  56. <b>Note</b>:</span> You must be a superuser to perform this task.</div>
  57. <a name="topic_4_2_1__ol_kss_btp_wj"><!-- --></a><ol class="ol" id="topic_4_2_1__ol_kss_btp_wj">
  58. <li class="li" id="topic_4_2_1__li_src_z3t_yj"><a name="topic_4_2_1__li_src_z3t_yj"><!-- --></a>Click <a name="topic_4_2_1__image_vv5_hnv_wj"><!-- --></a><img class="image" id="topic_4_2_1__image_vv5_hnv_wj" src="/static/art/help/quick_start.png"/>. The Quick Start Wizard opens.</li>
  59. <li class="li" id="topic_4_2_1__li_zgj_z3t_yj"><a name="topic_4_2_1__li_zgj_z3t_yj"><!-- --></a>Click <strong class="ph b">Step 2:
  60. Examples</strong>.</li>
  61. <li class="li">Click <strong class="ph b">Beeswax (Hive UI)</strong>.</li>
  62. </ol>
  63. </div>
  64. </div>
  65. <div class="topic concept nested1" xml:lang="en-US" lang="en-US" id="topic_4_3"><a name="topic_4_3"><!-- --></a>
  66. <h2 class="title topictitle2">Query Editor</h2>
  67. <div class="body conbody">
  68. <p class="p">The Query Editor view lets you create, save, and submit queries in the
  69. <a class="xref" href="http://wiki.apache.org/hadoop/Hive/LanguageManual" target="_blank">Hive Query Language (HQL)</a>,
  70. which is similar to Structured Query Language (SQL). When you submit a query, the Beeswax
  71. Server uses Hive to run the queries. You can either wait for the query to complete, or
  72. return later to find the queries in the History view. You can also request to receive an
  73. email message after the query is completed.</p>
  74. <p class="p">In the box to the left of the Query field, you can select a database,
  75. override the default Hive and Hadoop settings, specify file resources and user-defined
  76. functions, enable users to enter parameters at run-time, and request email notification when
  77. the job is complete. See <a class="xref" href="#topic_4_3_2">Advanced Query Settings</a> for details on using these settings. </p>
  78. </div>
  79. <div class="topic concept nested2" xml:lang="en-US" lang="en-US" id="topic_4_3_1"><a name="topic_4_3_1"><!-- --></a>
  80. <h3 class="title topictitle3">Creating Queries </h3>
  81. <div class="body conbody">
  82. <ol class="ol">
  83. <li class="li" id="topic_4_3_1__li_v2d_p5k_xj"><a name="topic_4_3_1__li_v2d_p5k_xj"><!-- --></a>In the Query Editor window, type a query or
  84. multiple queries separated by a semicolon ";". To be presented with a drop-down of
  85. autocomplete options, type <span class="ph uicontrol">CTRL+spacebar</span> when entering a query. </li>
  86. <li class="li" id="topic_4_3_1__li_ilk_p5k_xj"><a name="topic_4_3_1__li_ilk_p5k_xj"><!-- --></a>To save your query and advanced settings to use
  87. again later, click <strong class="ph b">Save As</strong>, enter a name and
  88. description, and then click <strong class="ph b">OK</strong>. To save changes to an
  89. existing query, click <strong class="ph b">Save.</strong>
  90. </li>
  91. <li class="li">If you want to view the execution plan for the query, click <strong class="ph b">Explain</strong>. For more information, see <a class="xref" href="http://wiki.apache.org/hadoop/Hive/LanguageManual/Explain" target="_blank">http://wiki.apache.org/hadoop/Hive/LanguageManual/Explain</a>.</li>
  92. </ol>
  93. </div>
  94. </div>
  95. <div class="topic concept nested2" id="concept_ch1_5gb_zj"><a name="concept_ch1_5gb_zj"><!-- --></a>
  96. <h3 class="title topictitle3">Loading Queries into the Query Editor</h3>
  97. <div class="body conbody">
  98. <a name="concept_ch1_5gb_zj__ol_kkg_vgb_zj"><!-- --></a><ol class="ol" id="concept_ch1_5gb_zj__ol_kkg_vgb_zj">
  99. <li class="li">Do one of the following:<a name="concept_ch1_5gb_zj__ul_xlq_jqb_zj"><!-- --></a><ul class="ul" id="concept_ch1_5gb_zj__ul_xlq_jqb_zj">
  100. <li class="li">Click the <span class="ph uicontrol">My Queries</span> tab.<a name="concept_ch1_5gb_zj__ol_qhz_lqb_zj"><!-- --></a><ol class="ol" type="a" id="concept_ch1_5gb_zj__ol_qhz_lqb_zj">
  101. <li class="li">Click the <span class="ph uicontrol">Recent Saved Queries</span> or <span class="ph uicontrol">Recent Run
  102. Queries</span> tab to display the respective queries. </li>
  103. </ol>
  104. </li>
  105. <li class="li">Click the <span class="ph uicontrol">Saved Queries</span> tab.</li>
  106. </ul>
  107. </li>
  108. <li class="li">Click a query name. The query is loaded into the Query Editor.</li>
  109. </ol>
  110. </div>
  111. </div>
  112. <div class="topic concept nested2" id="concept_xsr_yx1_zj"><a name="concept_xsr_yx1_zj"><!-- --></a>
  113. <h3 class="title topictitle3">Running Queries </h3>
  114. <div class="body conbody">
  115. <div class="note note" id="concept_xsr_yx1_zj__note_vbn_4xk_xj"><a name="concept_xsr_yx1_zj__note_vbn_4xk_xj"><!-- --></a><span class="notetitle"><img src="/static/art/help/note.jpg"/> 
  116. <b>Note</b>:</span> To run a query, you must be logged in to
  117. Hue as a user that also has a Unix user account on the remote server. </div>
  118. <a name="concept_xsr_yx1_zj__ol_rnw_yx1_zj"><!-- --></a><ol class="ol" id="concept_xsr_yx1_zj__ol_rnw_yx1_zj">
  119. <li class="li">To execute a portion of the query, highlight one or more query
  120. statements.</li>
  121. <li class="li">Click <strong class="ph b">Execute</strong>. The Query Results
  122. window appears with the results of your query. <a name="concept_xsr_yx1_zj__ul_f4w_yx1_zj"><!-- --></a><ul class="ul" id="concept_xsr_yx1_zj__ul_f4w_yx1_zj">
  123. <li class="li">To view a log of the query execution, click <strong class="ph b">Log</strong> at the top of the results display. You can use
  124. the information in this tab to debug your query.</li>
  125. <li class="li">To view the query that generated these results, click <strong class="ph b">Query</strong> at the top of the results display.</li>
  126. <li class="li">To view the columns of the query, click <strong class="ph b">Columns</strong>.</li>
  127. <li class="li">To return to the query in the Query Editor, click <strong class="ph b">Unsaved Query</strong>.</li>
  128. </ul>
  129. </li>
  130. <li class="li">If there are multiple statements in the query, click <span class="ph uicontrol">Next</span> in
  131. the Multi-statement query pane to execute the remaining statements.</li>
  132. </ol>
  133. <div class="note note"><span class="notetitle"><img src="/static/art/help/note.jpg"/> 
  134. <b>Note</b>:</span> Under <strong class="ph b">MR JOBS</strong>, you can view any MapReduce jobs that
  135. the query generated.</div>
  136. </div>
  137. </div>
  138. <div class="topic concept nested2" id="concept_axp_mgb_zj"><a name="concept_axp_mgb_zj"><!-- --></a>
  139. <h3 class="title topictitle3">Downloading and Saving Query Results</h3>
  140. <div class="body conbody">
  141. <div class="note important"><span class="importanttitle"><img src="/static/art/help/important.jpg"/> 
  142. <b>Important</b>:</span>
  143. <a name="concept_axp_mgb_zj__ul_p4w_yx1_zj"><!-- --></a><ul class="ul" id="concept_axp_mgb_zj__ul_p4w_yx1_zj">
  144. <li class="li">You can only save results to a file when the results were
  145. generated by a MapReduce job.</li>
  146. <li class="li">This is the preferred way to save when the result is large (for
  147. example &gt; 1M rows).</li>
  148. </ul>
  149. </div>
  150. <a name="concept_axp_mgb_zj__ol_agb_4gb_zj"><!-- --></a><ol class="ol" id="concept_axp_mgb_zj__ol_agb_4gb_zj">
  151. <li class="li">Do any of the following to download or save the query results: <a name="concept_axp_mgb_zj__ul_i4w_yx1_zj"><!-- --></a><ul class="ul" id="concept_axp_mgb_zj__ul_i4w_yx1_zj">
  152. <li class="li">Click <strong class="ph b">Download as CSV</strong> to
  153. download the results in a comma-separated values file suitable for use in other
  154. applications.</li>
  155. <li class="li">Click <strong class="ph b">Download as XLS</strong> to
  156. download the results in a Microsoft Office Excel worksheet file.</li>
  157. <li class="li">Click <strong class="ph b">Save</strong> to save the
  158. results in a table or HDFS file.<a name="concept_axp_mgb_zj__ul_m4w_yx1_zj"><!-- --></a><ul class="ul" id="concept_axp_mgb_zj__ul_m4w_yx1_zj">
  159. <li class="li">To save the results in a new table, select <strong class="ph b">In a new table</strong>, enter a table name, and then
  160. click <strong class="ph b">Save</strong>.</li>
  161. <li class="li">To save the results in an HDFS file, select <strong class="ph b">In an HDFS directory</strong>, enter a path and then
  162. click <strong class="ph b">Save</strong>. You can then download the file
  163. with <a class="xref" href="filebrowser.html#topic_6">File Browser</a>. </li>
  164. </ul>
  165. </li>
  166. </ul>
  167. </li>
  168. </ol>
  169. </div>
  170. </div>
  171. <div class="topic concept nested2" xml:lang="en-US" lang="en-US" id="topic_4_3_2"><a name="topic_4_3_2"><!-- --></a>
  172. <h3 class="title topictitle3">Advanced Query Settings </h3>
  173. <div class="body conbody">
  174. <p class="p">The pane to the left of the Query Editor lets you specify the
  175. following options: </p>
  176. <div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" class="table" frame="hsides" border="1" rules="all">
  177. <thead class="thead" align="left">
  178. <tr class="row">
  179. <th class="entry" valign="top" width="16.666666666666664%" id="d5062e390">
  180. <p class="p">
  181. <strong class="ph b">Option</strong>
  182. </p>
  183. </th>
  184. <th class="entry" valign="top" width="83.33333333333334%" id="d5062e399">
  185. <p class="p">
  186. <strong class="ph b">Description</strong>
  187. </p>
  188. </th>
  189. </tr>
  190. </thead>
  191. <tbody class="tbody">
  192. <tr class="row">
  193. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  194. <p class="p"><strong class="ph b">DATABASE</strong>
  195. </p>
  196. </td>
  197. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  198. <p class="p">The database containing the table definitions. </p>
  199. </td>
  200. </tr>
  201. <tr class="row">
  202. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  203. <p class="p"><strong class="ph b">SETTINGS</strong>
  204. </p>
  205. </td>
  206. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  207. <div class="p">Override the Hive and Hadoop default settings. To configure
  208. a new setting: <a name="topic_4_3_2__ol_k5v_hcc_zj"><!-- --></a><ol class="ol" id="topic_4_3_2__ol_k5v_hcc_zj">
  209. <li class="li">Click <strong class="ph b">Add</strong>.</li>
  210. <li class="li">For <strong class="ph b">Key</strong>, enter a Hive or Hadoop
  211. configuration variable name. </li>
  212. <li class="li">For <strong class="ph b">Value</strong>, enter the value you want to
  213. use for the variable. </li>
  214. </ol>
  215. </div>
  216. <p class="p">For example, to override the directory where structured
  217. Hive query logs are created, you would enter <samp class="ph codeph">hive.querylog.location</samp> for <strong class="ph b">Key</strong>, and a path for <strong class="ph b">Value.</strong>
  218. </p>
  219. <p class="p">To view the default settings, click the <strong class="ph b">Settings</strong> tab at the top of the page. For
  220. information about Hive configuration variables, see: <a class="xref" href="http://wiki.apache.org/hadoop/Hive/AdminManual/Configuration" target="_blank">http://wiki.apache.org/hadoop/Hive/AdminManual/Configuration</a>. For
  221. information about Hadoop configuration variables, see: <a class="xref" href="http://hadoop.apache.org/docs/current/hadoop-mapreduce-client/hadoop-mapreduce-client-core/mapred-default.xml" target="_blank">http://hadoop.apache.org/docs/current/hadoop-mapreduce-client/hadoop-mapreduce-client-core/mapred-default.xml</a>.</p>
  222. </td>
  223. </tr>
  224. <tr class="row">
  225. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  226. <p class="p"><strong class="ph b">FILE RESOURCES</strong>
  227. </p>
  228. </td>
  229. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  230. <div class="p">Make files locally accessible at query execution time
  231. available on the Hadoop cluster. Hive uses the Hadoop Distributed Cache to
  232. distribute the added files to all machines in the cluster at query execution
  233. time.<a name="topic_4_3_2__ol_flf_vfc_zj"><!-- --></a><ol class="ol" id="topic_4_3_2__ol_flf_vfc_zj">
  234. <li class="li">Click <strong class="ph b">Add</strong> to
  235. configure a new setting.</li>
  236. <li class="li">From the <strong class="ph b">Type</strong>
  237. drop-down menu, choose one of the following:<a name="topic_4_3_2__ul_bkb_wfc_zj"><!-- --></a><ul class="ul" id="topic_4_3_2__ul_bkb_wfc_zj">
  238. <li class="li">
  239. <strong class="ph b">jar</strong> — Adds the specified resources to
  240. the Java classpath.</li>
  241. <li class="li"><strong class="ph b">archive</strong> —
  242. Unarchives the specified resources when distributing them. </li>
  243. <li class="li"><strong class="ph b">file</strong> — Adds the
  244. specified resources to the distributed cache. Typically, this might be a
  245. transform script (or similar) to be executed. </li>
  246. </ul>
  247. </li>
  248. <li class="li">For <strong class="ph b">Path</strong>, enter the
  249. path to the file or click <a name="topic_4_3_2__image_sdp_cgc_zj"><!-- --></a><img class="image" id="topic_4_3_2__image_sdp_cgc_zj" src="/static/art/help/browse.png"/> to browse and select the file.  </li>
  250. </ol>
  251. </div>
  252. <div class="note note"><span class="notetitle"><img src="/static/art/help/note.jpg"/> 
  253. <b>Note</b>:</span> It is not necessary to specify files used in a
  254. transform script if the files are available in the same path
  255. on all machines in the Hadoop cluster.</div>
  256. </td>
  257. </tr>
  258. <tr class="row">
  259. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  260. <p class="p"><strong class="ph b">USER-DEFINED FUNCTIONS</strong>
  261. </p>
  262. </td>
  263. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  264. <p class="p">Specify user-defined functions. Click <strong class="ph b">Add</strong> to configure a new setting. Specify the
  265. function name in the <strong class="ph b">Name</strong> field, and specify
  266. the class name for <strong class="ph b">Class</strong>
  267. <strong class="ph b">name</strong>. </p>
  268. <p class="p">You <em class="ph i">must</em> specify a JAR file for the user-defined
  269. functions in <strong class="ph b"><strong class="ph b">FILE
  270. RESOURCES</strong></strong>. </p>
  271. <p class="p">To include a user-defined function in a query, add a $
  272. (dollar sign) before the function name in the query. For example, if <var class="keyword varname">MyTable</var> is a user-defined
  273. function name in the query, you would type: <samp class="ph codeph">SELECT * $</samp><samp class="ph codeph"><var class="keyword varname">MyTable</var></samp>
  274. </p>
  275. </td>
  276. </tr>
  277. <tr class="row">
  278. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  279. <p class="p"><strong class="ph b">PARAMETERIZATION</strong>
  280. </p>
  281. </td>
  282. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  283. <p class="p">Indicate that a dialog box should display to enter parameter
  284. values when a query containing the string $<var class="keyword varname">parametername</var> is
  285. executed. Enabled by default. </p>
  286. </td>
  287. </tr>
  288. <tr class="row">
  289. <td class="entry" valign="top" width="16.666666666666664%" headers="d5062e390 ">
  290. <p class="p"><strong class="ph b">EMAIL NOTIFICATION</strong>
  291. </p>
  292. </td>
  293. <td class="entry" valign="top" width="83.33333333333334%" headers="d5062e399 ">
  294. <p class="p">Indicate that an email message should be sent after a query
  295. completes. The email is sent to the email address specified in the logged-in
  296. user's profile. </p>
  297. </td>
  298. </tr>
  299. </tbody>
  300. </table>
  301. </div>
  302. </div>
  303. </div>
  304. <div class="topic concept nested2" xml:lang="en-US" lang="en-US" id="topic_4_3_3"><a name="topic_4_3_3"><!-- --></a>
  305. <h3 class="title topictitle3">Viewing Query History </h3>
  306. <div class="body conbody">
  307. <p class="p">You can view the history of queries that you have run previously.
  308. Results for these queries are available for one week or until Hue is restarted. </p>
  309. <ol class="ol">
  310. <li class="li">Click <strong class="ph b">History</strong>. A list of your
  311. saved and unsaved queries displays in the Query History window.</li>
  312. <li class="li">To display the queries for all users, click <strong class="ph b">Show everyone's queries</strong>.
  313. To display your queries only, click <strong class="ph b">Show my queries</strong>.</li>
  314. <li class="li">To display the automatically generated actions performed on a
  315. user's behalf, click <strong class="ph b">Show auto actions</strong>. To display
  316. user queries again, click <strong class="ph b">Show user queries</strong>.</li>
  317. </ol>
  318. </div>
  319. </div>
  320. <div class="topic concept nested2" xml:lang="en-US" lang="en-US" id="topic_4_3_4"><a name="topic_4_3_4"><!-- --></a>
  321. <h3 class="title topictitle3">Viewing, Editing, Copying, and Deleting
  322. Saved Queries </h3>
  323. <div class="body conbody">
  324. <p class="p">You can view a list of saved queries of all users by clicking <strong class="ph b">My
  325. Queries</strong> and then selecting either <span class="ph uicontrol">Recent Saved Queries</span> or
  326. <span class="ph uicontrol">Recent Run Queries</span> tab to display the respective queries or
  327. clicking <strong class="ph b">Saved Queries</strong>. You can copy any query, but you
  328. can edit, delete, and view the history of only your own queries. </p>
  329. <div class="tablenoborder"><a name="topic_4_3_4__table_rxy_gdh_b3"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="topic_4_3_4__table_rxy_gdh_b3" class="table" frame="hsides" border="1" rules="all">
  330. <thead class="thead" align="left">
  331. <tr class="row">
  332. <th class="entry" valign="top" width="25%" id="d5062e719">Saved Query</th>
  333. <th class="entry" valign="top" width="75%" id="d5062e722">Procedure</th>
  334. </tr>
  335. </thead>
  336. <tbody class="tbody">
  337. <tr class="row">
  338. <td class="entry" valign="top" width="25%" headers="d5062e719 ">
  339. <p class="p">
  340. <strong class="ph b">Edit</strong>
  341. </p>
  342. </td>
  343. <td class="entry" valign="top" width="75%" headers="d5062e722 ">
  344. <div class="p">
  345. <a name="topic_4_3_4__ol_hbl_xbh_dk"><!-- --></a><ol class="ol" id="topic_4_3_4__ol_hbl_xbh_dk">
  346. <li class="li">Click <strong class="ph b">Saved Queries</strong>.
  347. The Queries window displays.</li>
  348. <li class="li">Check the checkbox next to the query and click <strong class="ph b">Edit</strong>. The query displays in the Query
  349. Editor window.</li>
  350. <li class="li">Change the query and then click <strong class="ph b">Save.</strong> You can also click <strong class="ph b">Save As</strong>, enter a new name, and click <strong class="ph b">OK</strong> to save a copy of the query.</li>
  351. </ol>
  352. </div>
  353. </td>
  354. </tr>
  355. <tr class="row">
  356. <td class="entry" valign="top" width="25%" headers="d5062e719 ">
  357. <p class="p">
  358. <strong class="ph b">Copy</strong>
  359. </p>
  360. </td>
  361. <td class="entry" valign="top" width="75%" headers="d5062e722 ">
  362. <div class="p">
  363. <a name="topic_4_3_4__ol_dqp_xbh_dk"><!-- --></a><ol class="ol" id="topic_4_3_4__ol_dqp_xbh_dk">
  364. <li class="li">Click <strong class="ph b">Saved Queries</strong>.
  365. The Queries window displays.</li>
  366. <li class="li">Check the checkbox next to the query and click <strong class="ph b">Copy</strong>. The query displays in the Query
  367. Editor window.</li>
  368. <li class="li">Change the query as necessary and then click <strong class="ph b">Save.</strong> You can also click <strong class="ph b">Save As</strong>, enter a new name, and click <strong class="ph b">OK</strong> to save a copy of the query.</li>
  369. </ol>
  370. </div>
  371. </td>
  372. </tr>
  373. <tr class="row">
  374. <td class="entry" valign="top" width="25%" headers="d5062e719 ">
  375. <p class="p">
  376. <strong class="ph b">Copy in Query History</strong>
  377. </p>
  378. </td>
  379. <td class="entry" valign="top" width="75%" headers="d5062e722 ">
  380. <div class="p">
  381. <a name="topic_4_3_4__ol_ut5_xbh_dk"><!-- --></a><ol class="ol" id="topic_4_3_4__ol_ut5_xbh_dk">
  382. <li class="li">Click <strong class="ph b">History</strong>. The
  383. Query History window displays.</li>
  384. <li class="li">To display the queries for all users, click <strong class="ph b">Show everyone's queries</strong>. The queries for
  385. all users display in the History window.</li>
  386. <li class="li">Click the query you want to copy. A copy of the query
  387. displays in the Query Editor window.</li>
  388. <li class="li">Change the query, if necessary, and then click <strong class="ph b">Save As</strong>, enter a new name, and click <strong class="ph b">OK</strong> to save the query.</li>
  389. </ol>
  390. </div>
  391. </td>
  392. </tr>
  393. <tr class="row">
  394. <td class="entry" valign="top" width="25%" headers="d5062e719 ">
  395. <p class="p">
  396. <strong class="ph b">Delete</strong>
  397. </p>
  398. </td>
  399. <td class="entry" valign="top" width="75%" headers="d5062e722 ">
  400. <a name="topic_4_3_4__ol_fgh_1vc_zj"><!-- --></a><ol class="ol" id="topic_4_3_4__ol_fgh_1vc_zj">
  401. <li class="li">Click <strong class="ph b">Saved Queries</strong>.
  402. The Queries window displays.</li>
  403. <li class="li">Check the checkbox next to the query and click <strong class="ph b">Delete</strong>.</li>
  404. <li class="li">Click <strong class="ph b">Yes</strong> to confirm
  405. the deletion.</li>
  406. </ol>
  407. </td>
  408. </tr>
  409. </tbody>
  410. </table>
  411. </div>
  412. </div>
  413. </div>
  414. </div>
  415. </body>
  416. </html>