About poojachawda_10

poojachawda_10 · ‎06-12-2017

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

poojachawda_10 · ‎06-07-2017

@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.

poojachawda_10 · ‎06-06-2017

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);

poojachawda_10 · ‎02-25-2016

@Kuldeep Kulkarni thanks it worked for me.

poojachawda_10 · ‎02-25-2016

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?

poojachawda_10 · ‎02-22-2016

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 ......................

poojachawda_10 · ‎02-22-2016

@Benjamin Leonhardi Using \ or \\ does't work. It gives the same error

poojachawda_10 · ‎02-18-2016

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?

Online	Offline
Last Visited	‎08-15-2019 08:33 PM

Member Since	‎02-18-2016 06:49 AM
Last Visited	‎08-15-2019 08:33 PM
Posts	8
Kudos received	11

Cloudera Community

Re: How to get the desired grouping result pig

Re: How to insert NULL value into Hive complex col...

Re: Override default Hive Database Path

Re: How to get the desired grouping result pig

Re: Beeline select query

Beeline select query

Re: Beeline hivevar value with spaces and symbols

Re: Beeline hivevar value with spaces and symbols

Beeline hivevar value with spaces and symbols