Hi all, I would like to change number format on TERMS panel in my Banana dashboard. File size stored in Solr collection field is now in Bytes. I would like to display that number in GB or MB on Banana dashboard. How can I do that. I found TERMS panel source code in Banana folder on Solr server, and probably line of code in module.js file which is responsible to display number. if (item) { var value = scope.panel.chart === 'bar' ? item.datapoint[1] : item.datapoint[1][0][1]; // if (scope.panel.mode === 'count') { // value = value.toFixed(0); // } else { // value = value.toFixed(scope.panel.decimal_points); // } $tooltip .html( kbn.query_color_dot(item.series.color, 20) + ' ' + item.series.label + " (" + dashboard.numberWithCommas(value.toFixed(scope.panel.decimal_points)) +")" ) But after changes to that file, nothing happens. I tried to clear Chrome cache, to restart Solr server and to create new terms panel, but also nothing happens. Please help me. BR, Tom ... View more

Hi to all, I've got folder on HDFS with multiple files with the same identifier in the filename, i.e. XXXX_XXXX_XXXX_XXXX_1944_XXXX_XXXX.parquet (1944 is identifier) How can I copy only first three or only three files with the same identifier to another folder on HDFS using Nifi? Any ideas how to achieve that? I would appreciate it a lot. Thank you, Tom ... View more

Hi all, I nifi I have an attribute with filename from which I extracted date with substring (only yyyyMMdd portion). After that I want to calculate year week number for date 2018/08/19 (formated from string portion 20180819024112) which is week number 33. If I use format without specified timezone ('GMT'), I get week number 34, but with specified timezone I get correct week number 33. What is the difference? Why do I get wrong week number without timezone. GMT is only +2 hours from 19th of August Midnight. Thanks, Tom ... View more

Hi to all, I configured Nifi on HDP cluster to authenticate users using kerberos. HDP 2.6.0.3 Ambari 2.5.0.3 Nifi 1.2.0 I changed nifi.properties, authorizers.xml and login-identity-providers.xml ccording to docs and when I restarted Nifi a get this in nifi-app.log Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'x509AuthenticationProvider' defined in class path resource [nifi-web-security-context.xml]: Cannot resolve reference to bean 'authorizer' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authorizer': FactoryBean threw exception on object creation; nested exception is java.lang.Exception: Unable to load the authorizer configuration file at: /usr/hdf/current/nifi/conf/authorizers.xml Caused by: org.xml.sax.SAXParseException: cvc-complex-type.2.4.a: Invalid content was found starting with element 'userGroupProvider'. One of '{authorizer}' is expected. Authorizer is managed-authorizer and I put xml conf in following order <userGroupProvider> <accessPolicyProvider> <authorizer> I even try to formatt XML config entries in case it can't parse XML, but exception is still there after restart. Any ideas? Thank you. ... View more

Hi to all, Ambari shows alerts on Zookeper service and Ambari Infra service with this message on the picture in attachement. Host is also a zookeeper server and Namenode. I tried with synchronizing server clocks, but nothing. HDP version: 2.6.0.3 Ambari version: 2.5.0.3 An ideas? Thank you! ... View more

Hi to all, recently I noticed that creating pandas dataframe in Jupyter is very slow. I'm using HDP as data storage and the data is stored in Hive tables in parquet format. Table dimensions are not so big, 11 columns and 145719 rows. When I connect from jupyter cell to HiveServer (using pyhive library), data retrieval is very slow (query is <Select * from table_name>) I also tried different connection libraries, pyhs2 and impyla and there is no reduction in cell execution time. It tooks for 6 min to execute jupyter cell and to create pandas dataframe. When I run query in Hue, exec time is in ms. I tried to configure Hive like below and nothing happend: - TEZ as execution engine - CBO neabled - set hive.exec.parallel=true') - set hive.vectorized.execution.enabled = true - set hive.vectorized.execution.reduce.enabled = true I also tried to compute table statistics and nothing happend: set hive.compute.query.using.stats=true set hive.stats.fetch.column.stats=true set hive.stats.fetch.partition.stats=true ANALYZE TABLE <table_name> COMPUTE STATISTICS FOR COLUMNS ANALYZE TABLE <table_name> COMPUTE STATISTICS I don't know if there are some Network issues or memory issues, because Jupyter is not on the server where the data is. Hardware configuration is not bad for both servers. Can someone share some info or ideas what is going on? Thanks! ... View more