keberos authentication is not enabled i have hue and hive in same server [beeswax] # Host where HiveServer2 is running. # If Kerberos security is enabled, use fully-qualified domain name (FQDN). hive_server_host=xxx.xxx.x.xxx # Port where HiveServer2 Thrift server runs on. hive_server_port=10000 Search data and saved documents... hue Task History 3 days ago Creating database sdatabase 3 days ago Creating database saname Jobs Hive Databases (0) Error loading databases. Hive Sample: Customers Email Survey Opt-Ins, Customers for Shipping ZIP Code, Total Amount per Order text 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 -- Get email survey opt-in values for all customers SELECT c.id, c.name, c.email_preferences.categories.surveys FROM customers c; -- Select customers for a given shipping ZIP Code SELECT customers.id, customers.name FROM customers WHERE customers.addresses['shipping'].zip_code = '76710'; -- Compute total amount per order for all customers Query History Saved Queries Query Builder 7 days ago Sample: Customers -- Get email survey opt-in values for all customers SELECT c.id, c.name, c.email_preferences.categories.surveys FROM customers c; -- Select customers for a given shipping ZIP Code SELECT customers.id, customers.name FROM customers WHERE customers.addresses['shipping'].zip_code = '76710'; -- Compute total amount per order for all customers SELECT c.id AS customer_id, c.name AS customer_name, ords.order_id AS order_id, SUM(order_items.price * order_items.qty) AS total_amount FROM customers c LATERAL VIEW EXPLODE(c.orders) o AS ords LATERAL VIEW EXPLODE(ords.items) i AS order_items GROUP BY c.id, c.name, ords.order_id; Assistant Functions Tables Statement 1/3 default.customers Sessions Hive Recreate Close Add a property...FilesFunctionsSettings i have changed the port and tried but same issue Could not connect to 192.168.1.137:10000
... View more
