About vinayk

vinayk · ‎10-06-2019

Hi, I'm facing same issue. Have there any luck?

vinayk · ‎08-08-2019

Hey Harsh Thanks for responding. As multiple client are requesting data to hbase, at some point, sometimes user don’t get data, EOF exception or connection interruptions occur. We are not able to track the record of requested data and size of input and output data sending to end user. Regards Vinay K

vinayk · ‎05-28-2019

@PJ you can use * in database column while define policy in ranger's hive plugin. * will apply restriction policy for all hive DB.

vinayk · ‎05-28-2019

Hi @Haijin Li The input file you are using is incorrect stock2.json {"myid":"0001","mytype":"donut"} command is correct CREATE EXTERNAL TABLE stock4_json (myjson struct<myid:string, mytype:string>)ROW FORMAT SERDE 'org.apache.hive.hcatalog.data.JsonSerDe' LOCATION '/warehouse/tablespace/external/hive/haijintest.db/stock2'; myjson struct define it is having further list and map. You have to place correct input file stock3.json {"myjson":{"myid":"0001","mytype":"donut"}} and create table with same command and check. Let me know if still you are facing issue. Regards, Vinay K

vinayk · ‎05-28-2019

Hi @PJ It depends on you, how you define policies for hive DB. You may restrict by multiple ranger policies. What is your exactly question can you explain it?

vinayk · ‎04-12-2019

Hi I'm planning to use hbase, where i've written code in hbase java api and running query. Have there any way to check the executed query in logs as well the response from query in logs?

vinayk · ‎01-10-2019

Almost, we had done. Thanks again @Geoffrey Shelton Okot

vinayk · ‎01-07-2019

Thanks @Geoffrey Shelton Okot

vinayk · ‎01-07-2019

Thanks @subhash parise

vinayk · ‎01-04-2019

@Geoffrey Shelton Okot Yes interactive query is running fine. i have edited below properties in custom spark2-default configuration: spark.sql.hive.hiveserver2.jdbc.url.principal spark.hadoop.hive.zookeeper.quorum spark.hadoop.hive.llap.daemon.service.hosts spark.datasource.hive.warehouse.load.staging.dir spark.datasource.hive.warehouse.metastoreUri spark.sql.hive.hiveserver2.jdbc.url After taken restart. run the spark-shell sql("show databases").show() still only DEFAULT database is visible.

Online	Offline
Last Visited	‎02-27-2020 09:15 AM

Member Since	‎04-12-2019 05:36 AM
Last Visited	‎02-27-2020 09:15 AM
Posts	105
Kudos received	3

Cloudera Community

Cloudera Community

Re: Querying JSON Data in Hive - returning null

Re: Can hive dB have multiple ranger policies?

Re: HDP3 upgradation failed with check keytabs ker...

Re: how yarn knows AD user

Re: user not found while running hive query from ...

Re: node manager going down continuously when i st...

Re: view queries and results in logs running from ...

Re: Can hive dB have multiple ranger policies?

Re: Querying JSON Data in Hive - returning null

Re: Can hive dB have multiple ranger policies?

view queries and results in logs running from hbas...

Re: Spark unable to connect Hive database in HDP 3...

Re: Spark unable to connect Hive database in HDP 3...

Re: Spark unable to connect Hive database in HDP 3...

Re: Spark unable to connect Hive database in HDP 3...