Most voted "hive" questions
10 questions
Sort by count of
-
1
votes0
answers32
viewsHow to perform a select with 2.7 billion records in every table?
By making a certain select in a table with about 2.7 billion records the Hive returns error. But including a LIMIT 2147483647, the select not of error. The problem is I need to sweep all table and…
-
1
votes2
answers99
viewsDifferent behaviors between Ine and Ive-e
In command execution using Beeline connection always works, but with Hive-e it does not work. That’s how it works: beeline -u jdbc:hive2://aaats879454co.sistema.br:10000/sistema…
-
1
votes0
answers55
viewsProblems connecting with Ive via Dbeaver
I have a problem connecting to Hive by Dbeaver! Could not open client transport with JDBC Uri: jdbc:hive2://b4fa09-edhhdinsightshadoopgbdev-Hdi-dev-Gb.azurehdinsight.net:443/finance_hz:…
-
1
votes1
answer49
viewsTurn a query into a HIVE file. CSV
I need to extract information from HIVE or Hue by generating a CSV file, I have tried some commands for both Hive and the Hue application but without success. Has anyone ever done anything like…
-
1
votes1
answer41
viewsSave results of a query in csv - Hortonworks Hive
Please, I tried the code below on Hive 1.2.1000.2.6.5.0-292 and there was an error. How can I extract data from a query in a csv without creating a table? hive --e 'select * from product limit 10;'…
-
0
votes1
answer55
viewsHow do I add a Primary in Hive version 0.14.0.2.0.0-2041?
How to add a Primary in Hive version 0.14.0.2.0.0-2041 ? Trying CREATE TABLE simple_rule ( simple_rule_id int(10) unsigned default '0' not null auto_increment, condition_analysis_id int(10) unsigned…
-
0
votes1
answer40
views -
0
votes0
answers23
viewsSQL - Managed Table vs External Table
I bring a less technical SQL question. I use Hadoop’s Hive tool to manipulate the data with SQL. And I would like to know a real situation where I should apply a Managed table and a External table.…
-
0
votes1
answer38
viewsError accessing Hive in Hortonworks Data Platform (HDP) on Hortonworks Sandbox
Good evening, you guys, I am trying to access Hive from Hortonworks Data Platform and an error is appearing. Could you help me? [root@sandbox-hdp ~]# Hive log4j:WARN No such Property…
hiveasked 4 years, 5 months ago Letícia Araujo 47 -
-1
votes0
answers15
viewsSeparate DDD from phone with HIVEQL
I have a table with fields DDD and Phone. Some were registered correctly, others the ddd is next to the phone and need to separate. CURRENT TABLE: UPDATED TABLE: I am starting my studies in HIVEQL,…