Re: Using Sqoop to get data from Impala/Hive to another Hive table

2017-02-21 Thread Mich Talebzadeh
regardless there is no point using Sqoop for such purpose. it is not really designed for it :) Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * h

Fwd: Enabling Tez-UI on CDH 5.8

2017-02-21 Thread Manoj Murumkar
Trying hive user group. Has anyone set Tez UI on CDH? If yes, what were the steps? Appreciate any help. -- Forwarded message -- From: Manoj Murumkar Date: Thu, Feb 16, 2017 at 12:02 PM Subject: Enabling Tez-UI on CDH 5.8 To: u...@tez.apache.org Hi, Wondering if anyone has succe

Hive LLAP

2017-02-21 Thread Vlad Gudikov
Hi everyone, Recently I was looking for some guides to configure LLAP. I've found out that it's possible to setup LLAP using Apache Slider. Is there any possibility of setuping LLAP without using Slider? Maybe configuration guide or something like this. Thanks in advance, Vlad

sqoop issue

2017-02-21 Thread Raj hadoop
I'm using hadoop 2.5.1 and sqoop 1.4.6. I am using sqoop import for importing table from mysql database to be used with hadoop. It is showing following error Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.fs.FSOutputSummer

Re: Using Sqoop to get data from Impala/Hive to another Hive table

2017-02-21 Thread Jörn Franke
From hive to hive another cluster I would use Hive Import/Export, if possible with Falcon instead of Sqoop. Sqoop always needs to do serialization/deserialization which is fine if the systems are different (e.g. Oracle -> Hive), but if it is the same system then usually it makes sense to use th

How to handle RAW data type of oracle in SQOOP import

2017-02-21 Thread Raj hadoop
How to handle RAW data type of oracle in SQOOP import

how add auth use hive AuthorizerV2 on spark2.1.0?

2017-02-21 Thread yuyong . zhai
hi i want add auth for sparksql read hive table,how? thx

Re: Using Sqoop to get data from Impala/Hive to another Hive table

2017-02-21 Thread Mich Talebzadeh
thanks Jorn. the idea is to test a big data high availability tool. by ingesting data to the target cluster. I have provisioned aan oracle schema for it so we can use Sqoop to get data into Hive. someone suggested try using sqoop to ingest from a hive table in one cluster to the target cluster.

Re: Using Sqoop to get data from Impala/Hive to another Hive table

2017-02-21 Thread Jörn Franke
Hallo, I have not tried it, but sqoop supports any jdbc driver. However, since the SQL syntax is not necessarily standardized you may face issues or performance problems. Hive itself has a nice import and export tool that supports also the metadata import/export. It can be orchestrated from Ooz

Using Sqoop to get data from Impala/Hive to another Hive table

2017-02-21 Thread Mich Talebzadeh
Hi, I have not tried this but someone mentioned that it is possible to use Sqoop to get data from one Impala/Hive table in one cluster to another? The clusters are in different zones. This is to test the cluster. Has anyone done such a thing? Thanks Dr Mich Talebzadeh LinkedIn * https://w