1. hadoop hive question stackoverflow.comI'm trying to create tables pragmatically using JDBC. However, I can't really see the table I created from the hive shell. What's worse, when i access hive shell from different directories, ... |
2. copy resultSet without using cachedRowSet stackoverflow.comI 'm trying to close the connection after executing a query. Before, I just create a CacheRowSetImpl instance and it will take care of release the resources for me. However, I ... |
3. Building Apache Hive - impossible to resolve dependencies stackoverflow.comI am trying out the Apache Hive as per http://wiki.apache.org/hadoop/Hive/GettingStarted and am getting this error from Ivy:
This error ... |
4. Hadoop Hive web interface options stackoverflow.comI've been experimenting with Hive for some data mining activities and would like to make it easily available to less command line orientated colleagues. Hive does now ship with a web interface ... |
5. Even data distribution on hadoop/hive stackoverflow.comI am trying a small hadoop setup (for experimentation) with just 2 machines. I am loading about 13GB of data, a table of around 39 million rows, with a replication factor ... |
6. How to connect to Hadoop/Hive from .NET stackoverflow.comI am working on a solution where I will have a Hadoop cluster with Hive running and I want to send jobs and hive queries from a .NET application to be ... |
7. Does Hive have a String split function? stackoverflow.comI am looking for a in-built String split function in Hive? E.g. if String is A|B|C|D|E then I want to have a function like array split(string input, char delimiter) so that I get back [A,B,C,D,E]. Does such ... |
8. Specifying compression codec for a INSERT OVERWRITE SELECT in Hive stackoverflow.comI have a hive table like
|
9. Ability to limit maximum reducers for a hadoop hive mapred job? stackoverflow.comI've tried prepending my query with:
And
The last one jailed a job with 530 reducers down to 35... which makes me think it was ... |
10. Hive, hadoop, and the mechanics behind hive.exec.reducers.max stackoverflow.comIn context of this other question here Using hive.exec.reducers.max directive has truely baffled me. From my perspective I thought hive worked on some sort of logic like, I have N # ... |
11. What are the consequences of adding a column to an exiting HIVE table? stackoverflow.comSuppose that a couple hundred Gigs after starting to use HIVE I want to add a column. From the various articles & pages I have seen, I cannot understand the consequences in ... |
12. How to make hive load meta store from certain path instead of creating at the current directory? stackoverflow.comI'm using Hive for some data processing. But whenever I start the Hive-Shell it creates a metastore at the current directory and I can not access to my tables which I ... |
13. How to convert .txt file to Hadoop's sequence file format stackoverflow.comTo effectively utilise map-reduce jobs in Hadoop, i need data to be stored in hadoop's sequence file format. However,currently the data is only in flat .txt format.Can ... |
14. Create temporary table in Hive? stackoverflow.comDoes Hive support temporary tables? I can't find it in the apache docs. |
15. Any Good Opensource Analytics front end tool? stackoverflow.comIs there any good open source web-based front end analytics tool that can talk to HIVE/HDFS for data ? |
16. Hadoop Hive - Split string stackoverflow.comI am a new hivebe. My Query : In the log file we have a request field like this "GET /img/home/search-user-ico.jpg HTTP/1.1" .There are more than 10,000 records are available. Example : "GET /img/home/search-user-ico.jpg ... |
17. Importing data from HDFS to Hive table stackoverflow.comI have my data in data/2011/01/13/0100/file in HDFS, each of thes file contain data in tab separated, say name, ip , url. I want to create a table in Hive and ... |
18. Hive / Hadoop / Flatfile: What is an efficient way to combine and concat rows stackoverflow.com
I'd like to combine this into 'collapsed' rows which look like this:
At the moment ... |
19. Hive - How can I write a create statement for a variable length, existing, hdfs file? stackoverflow.comSo, I have an existing hdfs directory, containing a bunch of files. These files are all tab delimited. I have a hive statement....
|
20. Hadoop Basics: What do I do with the output? stackoverflow.com(I'm sure a similar question exists, but I haven't found the answer I'm looking for yet.) I'm using Hadoop and Hive (for our developers with SQL familiarity) to batch process multiple ... |
21. MDX support for Hive (Hadoop) stackoverflow.comIs there any support for Multidimensional Expressions (MDX) for Hadoop's Hive ? |
22. Custom Map Reduce Program on Hive,whats the Rule?how about input and output? stackoverflow.comHello Fellow Developer,i got stuck a few day because i want to create custom map reduce program based on my query on hive,not few example i've found after googling and still ... |
23. How to configure hive server to run on remote mode? stackoverflow.comi added hive package to my hadoop cluster. if i go into hive cli, i can run hive in remote mode. but queries going through hive server runs in local mode ... |
24. What's the best way to support array column types with external tables in hive? stackoverflow.comSo i have external tables of tab delimited data. A simple table looks like this:
|
25. Hive installation issue while following Hive apache wiki step by step stackoverflow.comAfter installed Hive by the instruction on Hive apache wiki step by step, I invoked hive shell and typed "CREATE TABLE pokes (foo INT, bar STRING);", then it comes following error, ... |
26. Hive - create a table from zip file stackoverflow.comI have bunch of zip files of CSVs, that I want to create Hive table from. I'm trying to figure out what's the best way to do so.
|
27. Hadoop Hive Query: Multi-join stackoverflow.comHow can I do sub-selections in Hive? I think I might be making a really obvious mistake that's not so obvious to me...
Error I'm receiving: |
28. Is Apache Hive used more for the programming language or for the data warehouse aspects? stackoverflow.comI used to think that Hive was just a SQL-like programming language used to make writing MapReduce-type jobs easier (i.e., a SQL-like version of Pig/Pig Latin). I'm reading more about it ... |
29. COLLECT_SET() in Hive (Hadoop) stackoverflow.comI just learned about the collect_set() function in Hive, and I started a job on a development 3-node cluster. I only have about 10 GB to process. The job, however, is literally ... |
30. COLLECT_SET() in Hive, keep duplicates? stackoverflow.comIs there a way to keep the duplicates in a collected set in Hive, or simulate the sort of aggregate collection that Hive provides using some other method? I want to ... |
31. Hive - JobTracking? stackoverflow.comI've been through the methods, but I can't seem to find out how to extrapolate the % completed (like an eventListener!) of a job in Hive. Please help! EDIT ... |
32. sqoop import complete but hive show tables can't see table stackoverflow.comAfter install hadoop, hive (CDH version) I execute
All goes fine, but when I enter hive command line and execute ... |
33. Parsing and loading into Hive/Hadoop stackoverflow.comi am new to hadoop map reduce framework, and I am thinking of using hadoop map reduce to parse my data. I have thousands of big delimited files for which I ... |
34. Partition Hive table by existing field? stackoverflow.comCan I partition a Hive table upon insert by an existing field? I have a 10 GB file with a date field and an hour of day field. Can I load this ... |
35. Hive doesn't work on install stackoverflow.comI get the following error in Hive when executing any command.
This is in the hive.log.
|
36. What difference of RDBMS and Hive? stackoverflow.comIn RDMS like MySQL thereis database, are there database also on the Hive ?as i read on the manual, hive only have table, i bit confuse about it.. and what is different ... |
37. register hive udf using hue api stackoverflow.comCan anyone tell me how to register a UDF by using HUE API. I am using below code but its unable to register it.
|
38. Hive out-of-the-box json parser stackoverflow.comI have a text file containing json records I would like to load to Hive. My json looks like:
As you can see I have a nested json with arrays ... |
39. Create Datasource Hive on Pentaho hadoop stackoverflow.comI try pentaho hadoop to make report designer with Hive Datasource. I have make connection to hadoop with
Then I create datasource which I pointed ... |
40. Ignore a subdirectory in an external table in Apache Hive stackoverflow.comDoes Hive have a setting or a way of forcing it to ignore subdirectories when querying an external table? I have a subdirectory in my table folder that's not part of ... |
41. Problem running Hive on Hadoop stackoverflow.comI downloaded the latest Hive release 0.7.1. Cannot find hadoop installation: $HADOOP_HOME must be set or hadoop must be in the pathI went into this directory /home/hadoop/hive-0.7.1-bin/bin and tried ... |
42. Multiple volume & limit disk usage with Hadoop stackoverflow.comI am using Hadoop to processing on large set of data. I set up a hadoop node to use multiple volumes : one of these volume is a NAS with 10To ... |
43. Hadoop Hive DOUBLE type question stackoverflow.comQuick Hive/Hadoop question from a new user. I have a DOUBLE column that has "1.8E8" for value, does it mean I reached the max value for DOUBLE? |
44. Why Hive errors FileNotFoundException when a UDF use some external resource files but runs right at native? stackoverflow.comA UDF used some external resource files, then it error: "java.io.FileNotFoundException: resource/placeMap.txt (No such file or directory)", this function runs right at native, why wrong at hive, how can I solved it ... |
45. Hive : SerDe for mixed record types files stackoverflow.comI'm running Hive 071, and I have a multiple format record CSV file, |
46. How does Hive decide when to use map reduce and when not to? stackoverflow.comAs a simple example,
DOES NOT kick in map reduce, while
DOES. What is the general principle used to decide when to use map reduce (by hive)?
... |
47. java.io.IOException: No LZO codec found, cannot run stackoverflow.comI tried to use lzo in my hive script, but got this error message. It seemed that I did not have the class for lzo in the classpath. Did anyone else meet ... |
48. Hive: dynamic partition adding to external table stackoverflow.comI am running hive 071, processing existing data which is has the following directory layout: |
49. How to load data to hive from HDFS without removing the source file? stackoverflow.comLOAD DATA INPATH 'hdfs_file' INTO TABLE tablename; When load data from HDFS to hive, it looks like moving the hdfs_file to hive/warehouse dir, How can it copy but move? for the file will ... |
50. how to write subquery and use "In" Clause in Hive stackoverflow.comHow can I use In clause in Hive I want to write something like this in Hive select x from y where y.z in (select distinct z from y) order ... |
51. Custom InputFormat with Hive stackoverflow.comUpdate: Alright, it turns out the reason that the below isn't working is because I'm using a newer version of the |
52. How can I get the Hive JDBC driver and the Hive shell talk to the same DB? stackoverflow.comI have a hive sever running on default port 10000 started via: |
53. Pentaho data-integration with Hive CDH3u0 stackoverflow.comI want to try pentaho data integration CE v 4.2 with Hadoop Hive. i use Hive version from CDH3uO. I try to use demo pentaho for hadoop use file >> https://www.yousendit.com/download/UnlCOU1ld0F1Yk5FQlE9PQ but ... |
54. Does hive instantiate a new UDF object for each record? stackoverflow.comSay I'm building a UDF class called StaticLookupUDF that has to load some static data from a local file during construction. In this case I want to ensure that I'm not replicating ... |
55. How to get Hive working with bz2 ? stackoverflow.comSince bz2 is splittable and saves space, I'm planning to store the table data in bzip2 format. However it seems it's not recognizing the compressed format. It was fine with gzip format. The ... |
56. Developing web analytics with Hadoop stackoverflow.comI want to develop a web analytics platform in order to create aggregated data about web traffic (page views, visits, visitors, etc) by parsing apache access logs. Can I do it only ... |
57. Hadoop/Hive query to split one column into several ones stackoverflow.comI am using HIVE with two tables looking like (more or less): -TABLE1 defined as [(Variables : string),(Value1 : int),(Value2 : int)] with field "Variables" looking like "x0,x1,x2,x3,...,xn" -TABLE2 define as [(Value1Sum : int),(Value2Sum ... |
58. Hive: Create New Table from Existing Partitioned Table stackoverflow.comI'm using Amazon's Elastic MapReduce and I have a hive table created based on a series of log files stored in Amazon S3 and split in folders by day like so:
|
59. Problems in running Hive queries stackoverflow.comI have configured Hadoop and Hive on Windows through Cygwin. But I am facing some problems like: in hive terminal (CLI): hive> When I enter query, the query do not execute and terminal remains busy. If ... |