(Not supported for Separated-Value Output formats.
![dbvisualizer pass kerberos cache file dbvisualizer pass kerberos cache file](https://user-images.githubusercontent.com/1210849/121563156-01c47e80-c9cf-11eb-8104-664f02cf7136.png)
This is a Hive-specific setting in which variables can be set at the session level and referenced in Hive commands or queries.Ĭontrol whether color is used for display. Default is false. Properties that are listed in cannot be reset with hiveconf (see Restricted List and Whitelist). Use value for the given configuration property. This bug is fixed in version 0.13.0 ( HIVE-6359).īug fix (running -f in background): 1.3.0 and 2.0.0 ( HIVE-6758 ) workaround available for earlier versions Note: If the script contains tabs, query compilation fails in version 0.12.0. Support to run multiple SQL statements separated by semicolons in a single query_string: 1.2.0 ( HIVE-9877)īug fix (null pointer exception): 0.13.0 ( HIVE-5765 )īug fix (-headerInterval not honored): 0.14.0 ( HIVE-7647 )īug fix (running -e in background): 1.3.0 and 2.0.0 ( HIVE-6758) workaround available for earlier versions This option can be specified multiple times. Double or single quotes enclose the query string. The Beeline CLI supports these command line options: The changes can be adding, removing, or updating jar files.Įxecutes a Hive query and prints results to standard output. Removes the resource(s) from the distributed cache.Īs of Hive 1.2.0, removes the resource(s) which were added using the from the distributed cache. See Hive Resources for more information.Īs of Hive 0.14.0, makes HiveServer2 aware of any jar changes in the path specified by the configuration parameter .path (without needing to restart HiveServer2). (As of Hive 0.14.0: HIVE-7592).Ĭhecks whether the given resources are already added to the distributed cache or not. Lists the resources already added to the distributed cache. See Hive Resources for more information.Īs of Hive 1.2.0, adds one or more files, jars or archives to the list of resources in the distributed cache using an Ivy URL of the form ivy://group:module:version?query_string. See Hive Resources for more information. Prints all Hadoop and Hive configuration variables.Īdds one or more files, jars, or archives to the list of resources in the distributed cache. Prints a list of configuration variables that are overridden by the user or Hive.
![dbvisualizer pass kerberos cache file dbvisualizer pass kerberos cache file](http://computinggawer.weebly.com/uploads/1/3/3/4/133466310/649021919_orig.jpg)
Note: If you misspell the variable name, Beeline will not show an error. Sets the value of a particular configuration variable (key). Resets the configuration to the default values.