Unable to Create HDInsight(spark) cluster
I am trying to create a HDInsight (spark) cluster, and getting the error message below. Please advise. I have tried all different region and different node size, and I am getting the same error message. You have reached your subscription's cores…
Azure HDInsight Subscription Registration
I am currently having trouble w/ registering Microsoft.HDInsight on my subscription. Any recommendations? Do I need to create another subscription? Thanks.
Azure Subscription HDInsight Access
I had to create a new account so I could try to use HDInsight (I actually did not use any credits from current account). I currently am am trying to set up HDInsight cluster but my azure subscription says the following: The subscription is not registered…
HDInsight Cluster Deployment Failure
Hi. I currently am experiencing issues using Azure HDInsight cluster for a Mini-Project through Springboard. I am curious as to why I am receiving the following error after deploying my cluster: …
Automatically delete HDInsight cluster after period of inactivity
Hi, I have created an Azure template for creating HDInsight cluster. I would like to be able to set an option to delete the cluster after a period of inactivity. Ideally, I could set up this parameter during the creation and after (let's say) an…
HDInsight is spanned over availability zoned in region?
Hi I wonder how HDInsight fault tolerance is working. There are availability zones in each region, so I believe HDInsight's head nodes and worker nodes are spanned over these availability zones, but it's true? No matter how hard the failover works,…
When HDInsight worker node is stopped, the node will be automatically rebooted?
Hello As I described in this title, when HDInsight worker node is stopped for some reason(not for Azure infrastructure issue, but for the issue inside worker nodes stems from such as CPU or memory issues), the worker node will be automatically…
HDInsight cluster(Hadoop) creation problem
Hi, I need to use HDInsight sets(hadoop) for my homework for a short time. I called all the sources, but I couldn't upload them. I made a zone change for the solution did not work, I wrote 1 in the node field, but the problem was not solved, I think…
Cannot find and add the application 'Starburst Presto' to HDInsight, but how to install it?
Hi I'm new to Azure and trying to create HDInsight cluster. I would like to use presto on HDInsight. When creating a Hadoop cluster, HDInsight v4.0, and I tried to add the application Starburst Presto to the cluster on Configuration + pricing tab, …
Not able to limit the size of STDERR and STDOUT logs for Azure HDInsight deployed Spark Application!!!
I have tried editing the log4j properties file in https://CLUSTERNAME.azurehdinsight.net/#/main/services/SPARK2/configs, as mentioned in the following link: https://learn.microsoft.com/en-us/azure/hdinsight/spark/troubleshoot-debug-wasb I have done…
what is the Livy versions of all spark versions in HDInsight
Hi,I want to know the Livy version of different spark version in HDInsight. all the spark version is the pic below.
Spark metrics on HDInsight
Spark has a configurable metrics system based on the Dropwizard Metrics Library. This allows users to report Spark metrics to a variety of sinks including HTTP, JMX, and CSV files. I know that Spark on HDInsight can be connected to a Log Analytics…
Having issue installing mysql-connector-python package to Jupiter notebook on PySpark3 using Script Action-script failing
Here is my Script Action commands: !/usr/bin/env bash sudo /usr/bin/anaconda/bin/conda create --prefix /usr/bin/anaconda/envs/bgdatamysql python=3.5 anaconda --yes sudo /usr/bin/anaconda/bin/conda install -c anaconda mysql-connector-python -n…
Data Type and Format In External table PolyBase
Hello there, I am trying to query Azure Storage Account CDM csv file from SQL server on-prem. I created external table with all the data type as varchar. However, I need to display date time as datetime and need to remove double quote from string…
Outbound ports to HDInsight management
Hello, What are the required ports for outbound connection of HDInsight to management IPs and any other needed Azure services when configured with a resource provider connection set to ‘Outbound’? …
Collision on non-unique "headnodehost" hostname across HDInsight clusters
The context: Let's suppose I have multiple HdInsight4.0 clusters. Also suppose that I would like to access the Hadoop services eg jobhistory server running inside these clusters. Let's suppose I get the corresponding jobhistory address from each…
Azure HDInsight HBase - Create non-admin SSH user
I would like to create a standard user account on all HDInsight nodes that is a non-admin account. This will be used to login to the nodes and run some basic commands. There is an admin account created by default on all nodes, but is there a way for…
HWC and Hive (HDinsight): reserved keyword as a column name
with an attempt to save the dataframe for a table which has a column name 'timestamp' and SaveMode.Overwrite, the following exception occurs: org.apache.hadoop.hive.ql.parse.ParseException:line 1:47 cannot recognize input near 'timestamp' 'timestamp'…
Setting StatusFolder for HDInsight Spark job triggered through Data Factory
Currently our Spark job runs result in a number of folders with random guid names being created in the root directory of the container we use as our HDInsight cluster storage. This seems to be the folder in the context of which the job runs, it has a…
Outbound proxy to HDInsight management
Hello, How can we route traffic to HDInsight management through a proxy to avoid opening NSG outbound and also to not use an Azure firewall? https://learn.microsoft.com/en-us/azure/hdinsight/hdinsight-restrict-outbound-traffic Thank you, …