About wamshikreshna

wamshikreshna · ‎06-17-2019

hi @Geoffrey Shelton Okot, iam able create to materialized view for hive managed table ,but not external table ?

wamshikreshna · ‎06-15-2019

hi @Geoffrey Shelton Okot, Thanks for the reply, As per my understanding ,if we enable materialized views the table must have orc storage format and transnational, my doubt is when we create different storage format other than orc like (avro,text etc) did we apply materialized views if it works?

wamshikreshna · ‎06-15-2019

Hi team, Iam creating materialized view for a table ,for that getting below error.can any one help on this? create materialized view car1_mv as select * from cars; Error: Error while compiling statement: FAILED: SemanticException org.apache.hadoop.hive.ql.parse.SemanticException: Automatic rewriting for materialized view cannot be enabled if the materialized view uses non-transactional tables (state=42000,code=40000)

wamshikreshna · ‎05-10-2019

add this property in hive-site.xml tez.am.resource.memory.mb = 2048(depends on node size)

wamshikreshna · ‎01-16-2019

@Sindhu hi sindhu, what is the connection string for http mode of hive with kerberized cluster ,im unable to connect the sqlalchemy uri.for binary its working fine please help me out. i am getting below error to connect the http mode of hive (knox). ERROR: {"error": "Connection failed!\n\nThe error message returned was:\nTSocket read 0 bytes"} thanks in advance

wamshikreshna · ‎01-09-2019

@Geoffrey Shelton Okot hi geoffrey, can you look this error ,iam struggling with error ,if we remove ldap properties its working ,but im unable to connect to the hive. Please help me on this issue Thanks in advance. capture-superset.png

wamshikreshna · ‎01-07-2019

hi ,i am currently using hdp 3.0 and ambari 2.7,i need to install the nifi service on my cluster ,just followed the hortonworks document they said following query ambari-server install-mpack --mpack=http://.../hdf-mpack-name.tar.gz --purge --verbose added my centos7 package in the mpack. what we need to setup after?

wamshikreshna · ‎12-28-2018

I got the same error ,done with Same Configuration after adding LDAP properties im unable to login.

wamshikreshna · ‎12-26-2018

Thanks bro ! i get the log files only worker exiting related ,iam unable to check the error related logs ,where can i found this.

wamshikreshna · ‎12-26-2018

where its generated log files? i checked in the /var/logs/superset but ididnt find anything.

Online	Offline
Last Visited	‎01-02-2020 08:17 AM

Member Since	‎02-20-2018 09:01 AM
Last Visited	‎01-02-2020 08:17 AM
Posts	46
Kudos received	1

Cloudera Community

Re: creating materialized view getting below error...

Re: creating materialized view getting below error...

creating materialized view getting below error?

Re: Hive job failed using INSERT INTO TABLE with ...

Re: superset works with hive ?

Re: Superset error while trying to add HDP Hive da...

can we enable nifi in hdp 3.0?

Re: Superset error while trying to add HDP Hive da...

Re: where we can check the superset logs ?

Re: 500 error in superset ui?