Recent questions tagged hiveql

0 votes

744 views

1 answer

hiveql - How can I add a timestamp column in hive

I have 2 rows like below: 941 78 252 3008 86412 1718502 257796 2223252 292221 45514 114894 980 78 258 3064 ... hive without using pig script? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

568 views

1 answer

hiveql - How to use Hive Query results(multiple) in a variable for other query

I have two tables one is schools and one is students.I want to find all the students of a particular school. ... 346 and the result is null. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

446 views

1 answer

hiveql - hive-site.xml path in hive0.13.1

I'm a newbie. I would like to know the hive-site.xml and hive-default.xml files locations in hive-0.13.1 ... located in hive-0.13.1 version? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

474 views

1 answer

hiveql - Row number functionality in Hive

How can I generate row numbers for an existing table while running a select query? For example: select row_number ... format. Thanks in advance! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

338 views

1 answer

hiveql - Hive's unix_timestamp and from_unixtime functions

I am under the impression that unix_timestamp and from_unixtime Hive functions are 'reverse' of each other. When I try ... 's going on? Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

421 views

1 answer

hiveql - Can you explain when and why mapreduce is invoked in hive

select * from Table_name limit 5; select col1_name,col2_name from table_name limit 5; When i run the first query ... please explain the reason. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

332 views

1 answer

hiveql - I have created a table in hive, I would like to know which directory my table is created in?

I have created a table in hive, I would like to know which directory my table is created in? I would like to know the path... See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

486 views

1 answer

hiveql - How to Update/Drop a Hive Partition?

After adding a partition to an external table in Hive, how can I update/drop it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

299 views

1 answer

hiveql - What happens when a hive insert is failed halfway?

Suppose an insert is expected to load 100 records in hive and 40 records have been inserted and the insert ... after the insert query failed? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

428 views

1 answer

hiveql - metastore_db created wherever I run Hive

Folder metastore_db is created in any directory where I run Hive query. Is there any way to have only one ... do with hive.metastore.local? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

590 views

1 answer

hiveql - java.lang.RuntimeException:Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient

I have configured my Hive as given on link: http://www.youtube.com/watch?v=Dqo1ahdBK_A, but ... apache.hadoop.hive.metastore.HiveMetaStoreClient See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags