Member since
02-18-2016
8
Posts
11
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
955 | 06-06-2017 07:23 AM |
06-12-2017
09:09 AM
Hive does not support literals for complex types (array, map, struct, union), so it is not possible to use them in INSERT INTO...VALUES clauses. This means that the user cannot insert data into a complex datatype column using the INSERT INTO...VALUES clause. link
... View more
06-07-2017
07:10 AM
@Satish Sarapuri My default hive warehouse:
hive> dfs -ls /user/hive/warehouse/;
Found 8 items
drwxrwxrwx - hive hive 0 2016-02-22 23:04 /user/hive/warehouse/clickstream
drwxrwxrwx - hive hive 0 2015-12-02 21:52 /user/hive/warehouse/clickstream1
drwxrwxrwx - cloudera hive 0 2017-02-15 23:03 /user/hive/warehouse/emp1
drwxrwxrwx - cloudera hive 0 2016-09-07 23:10 /user/hive/warehouse/emp1_1
drwxrwxrwx - cloudera hive 0 2016-09-07 23:12 /user/hive/warehouse/emp1_2
drwxrwxrwx - cloudera hive 0 2017-02-15 23:03 /user/hive/warehouse/emp1_orc
drwxrwxrwx - cloudera hive 0 2016-09-07 23:09 /user/hive/warehouse/emp2
drwxrwxrwx - hive hive 0 2017-02-16 01:24 /user/hive/warehouse/employee Creating database without LOCATION: hive> create database testing1;
OK
Time taken: 0.048 seconds
hive> dfs -ls /user/hive/warehouse/;
Found 9 items
drwxrwxrwx - hive hive 0 2016-02-22 23:04 /user/hive/warehouse/clickstream
drwxrwxrwx - hive hive 0 2015-12-02 21:52 /user/hive/warehouse/clickstream1
drwxrwxrwx - cloudera hive 0 2017-02-15 23:03 /user/hive/warehouse/emp1
drwxrwxrwx - cloudera hive 0 2016-09-07 23:10 /user/hive/warehouse/emp1_1
drwxrwxrwx - cloudera hive 0 2016-09-07 23:12 /user/hive/warehouse/emp1_2
drwxrwxrwx - cloudera hive 0 2017-02-15 23:03 /user/hive/warehouse/emp1_orc
drwxrwxrwx - cloudera hive 0 2016-09-07 23:09 /user/hive/warehouse/emp2
drwxrwxrwx - hive hive 0 2017-02-16 01:24 /user/hive/warehouse/employee
drwxrwxrwx - cloudera hive 0 2017-06-06 23:38 /user/hive/warehouse/testing1.db Creating database with LOCATION: hive> create database testing location '/user/hive/testing';
OK
Time taken: 0.147 seconds
hive> dfs -ls /user/hive/;
Found 2 items
drwxrwxrwx - cloudera hive 0 2017-06-06 23:35 /user/hive/testing
drwxrwxrwx - hive hive 0 2017-02-15 23:01 /user/hive/warehouse
In hive explicit LOCATION is just a pointer.
... View more
06-06-2017
07:23 AM
2 Kudos
Hi @Andres Urrego, You need to modify your third step like. october_total_station = FOREACH october_station_gr GENERATE FLATTEN(group) , COUNT(october.s_station);
... View more
02-25-2016
09:52 AM
3 Kudos
I am trying to switch to Beeline from hive, but I have one issue.
Hive :
Query : select * from table; Output : The output is in readable format i.e we can scroll down to see complete data on my screen(terminal).
Beeline :
Query : select * from table; Output : The output is not in readable format i.e we cannot scroll down to see complete data. All columns are mixed up. Work Around :
I tried setting --maxWidth=100 it worked for one table with 10 columns. But still the output is not properly readable. I have to change the value of maxWidth for different tables as different tables have different number of columns.
So, is there any way to set some default value so that the data becomes understandable using beeline?
... View more
Labels:
- Labels:
-
Apache Hive
02-22-2016
10:58 AM
1 Kudo
Hi all, I am having the below senario, where the values in where clause is dynamic. beeline -u jdbc:hive2://<#####>/;auth=noSasl --silent=true --hivevar where_condition=" where modifyts >= '2016-02-18 00:55:43.00' and modifyts < '2016-02-18 00:55:44.0'" --hiveconf hive.auto.convert.join=false --hiveconf hive.optimize.skewjoin=true --hivevar destination_hive_table_name=<table> -f insert_delta_data.hql
22-02-2016 02:51:05 PST beeline_insert_into_k_gvt_inv_node_cntrl_tbl INFO - Usage: java org.apache.hive.cli.beeline.BeeLine
22-02-2016 02:51:05 PST beeline_xxxxx INFO - -u the JDBC URL to connect to
22-02-2016 02:51:05 PST beeline_xxxxx INFO - -n the username to connect as
22-02-2016 02:51:05 PST beeline_xxxxxNFO - -p the password to connect as
22-02-2016 02:51:05 PST ......................
... View more
02-22-2016
05:29 AM
1 Kudo
@Benjamin Leonhardi Using \ or \\ does't work. It gives the same error
... View more
02-18-2016
11:59 AM
3 Kudos
I am trying to pass a WHERE condition as a variable to hive hql via BeeLine. --hivevar somekey1='"someValue"'
works well --hivevar somekey2='"colum1<=someValue"'
does not work which prints the Beeline usage. How can I escape equal to (=)? Any help or pointers on how I can solve this issue?
... View more
Labels:
- Labels:
-
Apache Hive