About das_dineshk

das_dineshk · ‎08-13-2020

@stevenmatison Yes got your point ! but when you create a hive table with varchar (sufficient number)Can the columns datatype changed from varchar to string automatically!? When I create a view out of that table, the datatype is getting changed to string.

geeky_geek · ‎04-17-2020

@testingsauce I am also facing this issue. Saved df in HIVE using saveAsTable but when i try to fetch results using hiveContext.sql(query), it doesn't return anything. BADLY stuck. Please help

das_dineshk · ‎02-03-2018

its going blank no logs..

das_dineshk · ‎11-19-2017

@Marco Almeida Thank you for your help. I did try for various version of phoenix core but no luck lemme try this..

ssoldatov · ‎08-29-2017

As @ssattiraju mentioned you may use a file with commands providing it as a command line parameter. One quick note - if one of the commands fail, the script will stop executing. To avoid it you may use just simple redirect like: phoenix-sqlline localhost < file.sql

egarelnabi · ‎06-16-2017

@Dinesh Das Prohibition against dataset combinations: https://community.hortonworks.com/content/kbentry/63664/how-to-create-a-ranger-policy-that-prohibits-combi.html Data Expiry-based access policy: https://community.hortonworks.com/articles/92083/using-atlas-and-ranger-to-enforce-data-expiration.html Location-specific access policies: https://community.hortonworks.com/articles/57314/customizing-ranger-policies-with-dynamic-context.html As always, if you find this post helpful, don't forget to "accept" answer.

ssahi · ‎06-14-2017

Hi @Dinesh Das You might have better luck passing in the actual TRUNCATE TABLE statement in your sqoop eval using the --query option instead of trying to --call the stored procedure (I think those are only supported in sqoop export, not sqoop eval, but I could be mistaken). As always, if you find this post useful please "accept" the answer.

sagar_girish · ‎06-10-2017

Perfect answer!

saha_priyatam · ‎06-02-2017

You need to create external table then load data either from local or from HDFS. CREATE EXTERNAL TABLE <table_name> (column1 <datatype>,column2 <datatype>,column3 <datatype>,...) ROW FORMAT DELIMITED STORED AS SEQUENCEFILE LOCATION '<location_path>'; Now Load data : LOAD DATA INPATH '<HDFS PATH>' INTO <table_name>;

anaik · ‎06-05-2017

You can also use the atlas-client artifact (Java) to import the xls metadata into Atlas. I'd recommend going through atlas.incubator.apache.org/api/v2/index.html for an in-depth REST documentation for Atlas (0.8 onwards) Don't forget to upvote/accept the answer if you find it useful.

Online	Offline
Last Visited	‎08-13-2020 10:35 PM

Member Since	‎12-19-2016 01:09 PM
Last Visited	‎08-13-2020 10:35 PM
Posts	149
Kudos received	15

Cloudera Community

Re: Unable to install/start docker.

Re: how do I copy a file from aws ec2 instance to...

Re: Datatype from varchar to string in hive automa...

Re: save dataframe to a hive table

Re: HDP installation

Re: loading phoenix table using java

Re: Running sql script using phoenix

Re: Examples on Atlas/Ranger policies

Re: How to call a stored procudre in Sqoop

Re: Load data to external table using date field a...

Re: Loading sequence files to Hive table

Re: Can we connect Atlas with Sql table outside ha...