| clear query|facets|time |
Search criteria: .
Results from 1 to 10 from
15 (0.138s).
|
|
|
Loading phrases to help you refine your search...
|
|
Re: Mapping HBase table in Hive - Hive - [mail # user]
|
|
...Thanks Bejoy, Seems it worked, in the mapping of the column family I used ":key" and that's it, in addition as per some articles there should be no spaces in mapping, below is the crea...
|
|
|
Author: Ibrahim Yakti,
2013-01-13, 11:33
|
|
|
Re: Mapping HBase table in Hive - Hive - [mail # user]
|
|
...Thanks Bejoy, what do you mean by: suppose I used sqoop to move data from mysql to hbase and used id as a column family, all the other columns will be QF then, right? The ...
|
|
|
Author: Ibrahim Yakti,
2013-01-13, 08:22
|
|
|
Mapping HBase table in Hive - Hive - [mail # user]
|
|
...Hello, suppose I have the following table (orders) in MySQL: *************************** 1. row *************************** Field: id Type: int(10) unsigned &...
|
|
|
Author: Ibrahim Yakti,
2013-01-08, 12:45
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...Thanks Mohammad, I will be waiting ... meanwhile, seems I will get into HBase and give it a try ... unless someone advised with something better/easier. Ibrahim On Wed, Dec 26,...
|
|
|
Author: Ibrahim Yakti,
2012-12-26, 14:56
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...After more reading, a suggested scenario looks like: MySQL ---(Extract / Load)---> HDFS ---> Load into HBase --> Read as external in Hive ---(Transform Data & Join Tables)--&g...
|
|
|
Author: Ibrahim Yakti,
2012-12-26, 13:54
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...Mohammad, I am not sure if the answers & the link were to me or to Kshiva's question. if I have partitioned my data based on status for example, when I run the update query it will add...
|
|
|
Author: Ibrahim Yakti,
2012-12-26, 06:27
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...My problem is in eliminating the duplicates and only keep the correct data, any advise please? On Dec 24, 2012 9:13 PM, "Dean Wampler" wrote: ...
|
|
|
Author: Ibrahim Yakti,
2012-12-24, 18:25
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...Thanks Dean for the great reply, setting incremental import should be easy, if I partitioned my data how hive will get me the updated rows only considering that the row may have multiple fie...
|
|
|
Author: Ibrahim Yakti,
2012-12-24, 15:34
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...Bottom line: use sqoop to import data into HBase/Cassandra for storage and use Hive to query the data using external tables, did I miss anything? Ibrahim On Mon, Dec 24, 2012 a...
|
|
|
Author: Ibrahim Yakti,
2012-12-24, 14:41
|
|
|
Re: Reflect MySQL updates into Hive - Hive - [mail # user]
|
|
...Edward can you explain more please? you suggesting that I should use HBase for such tasks instead of hive? Ibrahim On Mon, Dec 24, 2012 at 5:28 PM, Edward Capriolo wrote:  ...
|
|
|
Author: Ibrahim Yakti,
2012-12-24, 14:29
|
|
|
|