11/20/2018

Getting Started with SQL Server vNext Early Adoption Program Big Data Analytics Step 2

Now that we've completed Step 1 of Getting Started with SQL Server vNext Early Adoption Program Big Data Analytics, we're ready to push forward with Step 2.  So let's begin.

Quickstart: Deploy SQL Server big data cluster on Azure Kubernetes Service (AKS)





Prerequisites:





To install the command line tool, we go to this link.





Will install using PowerShell...




Install-Script -Name install-kubectl -Scope CurrentUser -Force
install-kubectl.ps1 'C:\Program Files\kubectl'


First, had to create an account with https://www.powershellgallery.com/


Initiated the download...





Installed in local computer:





Now, install Python on Client machine...


https://www.python.org/


https://www.python.org/downloads/


Installed Successfully!





Verify Connection to AKS...



Install Pip:  https://pip.pypa.io/en/stable/installing/




From Azure Bash window: kubectl config view





Now set the Environment Variables in DOS Command Prompt - (don't include quotes in Password):




Next we create our SQL Server Big Data Cluster within our existing Cluster:



Now Deploy a Big Data Cluster:

mssqlctl create cluster

mssqlctl create cluster sqlbigdataclusterjb




Executed command from both DOS and PowerShell ISE, both run as Administrator:


mssqlctl create cluster sql2019bigdata


Received an error at this point:


2018-11-19 18:52:49.0138 UTC | INFO | Creating cluster...
Traceback (most recent call last):
  File "c:\program files (x86)\python37-32\lib\runpy.py", line 193, in _run_module_as_main
    "__main__", mod_spec)
  File "c:\program files (x86)\python37-32\lib\runpy.py", line 85, in _run_code
    exec(code, run_globals)
  File "C:\Program Files (x86)\Python37-32\Scripts\mssqlctl.exe\__main__.py", line 9, in
  File "c:\program files (x86)\python37-32\lib\site-packages\mssqlctl\__init__.py", line 1313, in main
    createCluster(args.name)
  File "c:\program files (x86)\python37-32\lib\site-packages\mssqlctl\__init__.py", line 804, in createCluster
    checkAndSetKubectlContext()
  File "c:\program files (x86)\python37-32\lib\site-packages\mssqlctl\__init__.py", line 963, in checkAndSetKubectlContext
    current_context = check_output("kubectl config current-context".split()).decode("utf-8").strip(" \t\n\r")
  File "c:\program files (x86)\python37-32\lib\subprocess.py", line 389, in check_output
    **kwargs).stdout
  File "c:\program files (x86)\python37-32\lib\subprocess.py", line 466, in run
    with Popen(*popenargs, **kwargs) as process:
  File "c:\program files (x86)\python37-32\lib\subprocess.py", line 769, in __init__
    restore_signals, start_new_session)
  File "c:\program files (x86)\python37-32\lib\subprocess.py", line 1172, in _execute_child
    startupinfo)
FileNotFoundError: [WinError 2] The system cannot find the file specified


And that's as far as I'm taking this for now.  The Python error has stopped in tracks, for now.

Thanks for reading~!