Member since
05-15-2018
34
Posts
0
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1166 | 05-15-2019 02:54 PM | |
2804 | 06-22-2018 03:27 PM |
05-15-2019
02:54 PM
c=a*(lit(1)-b)
... View more
01-16-2019
10:49 PM
@Venkat Use regexp_replace function in hive to replace $ with '' then cast to int. Example: select int(regexp_replace(string("124$"),'\\$',''));
+------+--+
| _c0 |
+------+--+
| 124 |
+------+--+
(or) Starting from Hive-1.3 version use replace function. select int(replace(string("124$"),'$',''));
+------+--+
| _c0 |
+------+--+
| 124 |
+------+--+
... View more
08-09-2018
08:35 PM
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy
... View more
08-04-2018
12:44 PM
1 Kudo
@Venkat It's an interface that allows tools like Pig, MapReduce and Spark to access and create Hive Tables and Views. See HCatalog
... View more
08-03-2018
03:17 PM
I don't think we have a way to write a .xslx file, However you can write csv or tsv which are compatible with excel.
... View more
07-20-2018
03:39 PM
I am asked about the Yarn Top .With the help of that command may I know the size of the cluster? and could please explain the attributes?
... View more
07-02-2018
02:34 PM
1 Kudo
A connection should be established before running the query. Pelase refer : https://community.hortonworks.com/articles/155890/working-with-beeline.html
... View more
06-26-2018
09:57 PM
1 Kudo
Here's one more good thread for HDFS small file problem. https://community.hortonworks.com/questions/167615/what-is-small-file-problem-in-hdfs.html
... View more
06-21-2018
02:20 PM
Sorry @ssharma it is working but when I trying like this
hive -e 'set hive.cli.print.header=true; create table test row format delimited fields terminated by '|' as select * from test1'>/home/yourfile.csv in this scenario it only showing the header not the whole data csv file
... View more