class TestSparkApi(object):
def setUp(self):
self.user = '******'
self.api = SparkApi(self.user)
def test_create_session_plain(self):
lang = 'pyspark'
properties = None
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
get_spark_api.return_value = Mock(
create_session=Mock(
return_value={'id': '1'}
),
get_session=Mock(
return_value={'state': 'idle', 'log': ''}
)
)
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
files_properties = [prop for prop in session['properties'] if prop['name'] == 'files']
assert_true(files_properties, session['properties'])
assert_equal(files_properties[0]['value'], [], session['properties'])
def test_get_jobs(self):
local_jobs = [
{'url': u'http://172.21.1.246:4040/jobs/job/?id=0', 'name': u'0'}
]
jobs = self.api._get_standalone_jobs(LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [
{'url': u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/', 'name': u'application_1444070328046_0002'}
]
jobs = self.api._get_yarn_jobs(LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)
class TestSparkApi(object):
def setUp(self):
self.user = '******'
self.interpreter = {
'name': 'livy',
'options': {
'api_url': 'http://gethue.com:8998'
},
}
self.api = SparkApi(self.user, self.interpreter)
def test_get_api(self):
lang = 'pyspark'
properties = None
# with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
spark_api = self.api.get_api()
assert_equal(spark_api.__class__.__name__, 'LivyClient')
def test_get_livy_props_method(self):
test_properties = [{
"name": "files",
"value": 'file_a,file_b,file_c',
}]
props = self.api.get_livy_props('scala', test_properties)
assert_equal(props['files'], ['file_a', 'file_b', 'file_c'])
def test_create_session_with_config(self):
lang = 'pyspark'
properties = None
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
with patch('notebook.connectors.spark_shell.DefaultConfiguration') as DefaultConfiguration:
with patch('notebook.connectors.spark_shell.USE_DEFAULT_CONFIGURATION') as USE_DEFAULT_CONFIGURATION:
DefaultConfiguration.objects.get_configuration_for_user.return_value = Mock(
properties_list=[
{'multiple': False, 'name': 'driverCores', 'defaultValue': 1, 'value': 2, 'nice_name': 'Driver Cores',
'help_text': 'Number of cores used by the driver, only in cluster mode (Default: 1)', 'type': 'number',
'is_yarn': True}]
)
get_spark_api.return_value = Mock(
create_session=Mock(
return_value={'id': '1'}
),
get_session=Mock(
return_value={'state': 'idle', 'log': ''}
)
)
# Case with user configuration. Expected 2 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
for p in session['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 2)
# Case without user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
DefaultConfiguration.objects.get_configuration_for_user.return_value = None
session2 = self.api.create_session(lang=lang, properties=properties)
assert_equal(session2['type'], 'pyspark')
assert_equal(session2['id'], '1')
for p in session2['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
# Case with no user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = False
session3 = self.api.create_session(lang=lang, properties=properties)
assert_equal(session3['type'], 'pyspark')
assert_equal(session3['id'], '1')
for p in session3['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
def test_create_session_plain(self):
lang = 'pyspark'
properties = None
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
get_spark_api.return_value = Mock(
create_session=Mock(
return_value={'id': '1'}
),
get_session=Mock(
return_value={'state': 'idle', 'log': ''}
)
)
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
files_properties = [prop for prop in session['properties'] if prop['name'] == 'files']
assert_true(files_properties, session['properties'])
assert_equal(files_properties[0]['value'], [], session['properties'])
def test_get_jobs(self):
local_jobs = [
{'url': u'http://172.21.1.246:4040/jobs/job/?id=0', 'name': u'0'}
]
jobs = self.api._get_standalone_jobs(LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [
{'url': u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/', 'name': u'application_1444070328046_0002'}
]
jobs = self.api._get_yarn_jobs(LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)
class TestSparkShellConnector(object):
LIVY_STANDALONE_LOG = """
Starting livy-repl on http://172.21.1.246:58449
Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
15/10/05 14:02:33 INFO SparkContext: Running Spark version 1.5.0
15/10/05 14:02:33 INFO SecurityManager: Changing view acls to: huetest
15/10/05 14:02:33 INFO SecurityManager: Changing modify acls to: huetest
15/10/05 14:02:33 INFO SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(huetest); users with modify permissions: Set(huetest)
15/10/05 14:02:33 INFO Slf4jLogger: Slf4jLogger started
15/10/05 14:02:33 INFO Remoting: Starting remoting
15/10/05 14:02:33 INFO Remoting: Remoting started; listening on addresses :[akka.tcp://[email protected]:58451]
15/10/05 14:02:33 INFO Utils: Successfully started service 'sparkDriver' on port 58451.
15/10/05 14:02:33 INFO SparkEnv: Registering MapOutputTracker
15/10/05 14:02:33 INFO SparkEnv: Registering BlockManagerMaster
15/10/05 14:02:33 INFO DiskBlockManager: Created local directory at /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/blockmgr-f63fdd28-6d86-4ae6-a91c-902fb0310fb4
15/10/05 14:02:33 INFO MemoryStore: MemoryStore started with capacity 530.0 MB
15/10/05 14:02:33 INFO HttpFileServer: HTTP File server directory is /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/httpd-0235b01f-ee8b-40fd-96a9-de946b1a3426
15/10/05 14:02:33 INFO HttpServer: Starting HTTP Server
15/10/05 14:02:33 INFO Utils: Successfully started service 'HTTP file server' on port 58452.
15/10/05 14:02:33 INFO SparkEnv: Registering OutputCommitCoordinator
15/10/05 14:02:33 INFO Utils: Successfully started service 'SparkUI' on port 4040.
15/10/05 14:02:33 INFO SparkUI: Started SparkUI at http://172.21.1.246:4040
15/10/05 14:02:34 INFO SparkContext: Added JAR file:/Users/huetest/Dev/hue/apps/spark/java/livy-assembly/target/scala-2.10/livy-assembly-3.9.0-SNAPSHOT.jar at http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar with timestamp 1444078954103
15/10/05 14:02:34 WARN MetricsSystem: Using default name DAGScheduler for source because spark.app.id is not set.
15/10/05 14:02:34 INFO Executor: Starting executor ID driver on host localhost
15/10/05 14:02:34 INFO Utils: Successfully started service 'org.apache.spark.network.netty.NettyBlockTransferService' on port 58453.
15/10/05 14:02:34 INFO NettyBlockTransferService: Server created on 58453
15/10/05 14:02:34 INFO BlockManagerMaster: Trying to register BlockManager
15/10/05 14:02:34 INFO BlockManagerMasterEndpoint: Registering block manager localhost:58453 with 530.0 MB RAM, BlockManagerId(driver, localhost, 58453)
15/10/05 14:02:34 INFO BlockManagerMaster: Registered BlockManager
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(130448) called with curMem=0, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_0 stored as values in memory (estimated size 127.4 KB, free 529.9 MB)
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(14276) called with curMem=130448, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_0_piece0 stored as bytes in memory (estimated size 13.9 KB, free 529.9 MB)
15/10/05 14:02:36 INFO BlockManagerInfo: Added broadcast_0_piece0 in memory on localhost:58453 (size: 13.9 KB, free: 530.0 MB)
15/10/05 14:02:36 INFO SparkContext: Created broadcast 0 from textFile at NativeMethodAccessorImpl.java:-2
15/10/05 14:02:36 INFO FileInputFormat: Total input paths to process : 1
15/10/05 14:02:36 INFO SparkContext: Starting job: collect at <stdin>:1
15/10/05 14:02:36 INFO DAGScheduler: Registering RDD 3 (reduceByKey at <stdin>:1)
15/10/05 14:02:36 INFO DAGScheduler: Registering RDD 7 (combineByKey at <stdin>:3)
15/10/05 14:02:36 INFO DAGScheduler: Got job 0 (collect at <stdin>:1) with 2 output partitions
15/10/05 14:02:36 INFO DAGScheduler: Final stage: ResultStage 2(collect at <stdin>:1)
15/10/05 14:02:36 INFO DAGScheduler: Parents of final stage: List(ShuffleMapStage 1)
15/10/05 14:02:36 INFO DAGScheduler: Missing parents: List(ShuffleMapStage 1)
15/10/05 14:02:36 INFO DAGScheduler: Submitting ShuffleMapStage 0 (PairwiseRDD[3] at reduceByKey at <stdin>:1), which has no missing parents
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(8960) called with curMem=144724, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_1 stored as values in memory (estimated size 8.8 KB, free 529.9 MB)
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(5483) called with curMem=153684, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_1_piece0 stored as bytes in memory (estimated size 5.4 KB, free 529.9 MB)
15/10/05 14:02:36 INFO BlockManagerInfo: Added broadcast_1_piece0 in memory on localhost:58453 (size: 5.4 KB, free: 530.0 MB)
15/10/05 14:02:36 INFO SparkContext: Created broadcast 1 from broadcast at DAGScheduler.scala:861
15/10/05 14:02:36 INFO DAGScheduler: Submitting 2 missing tasks from ShuffleMapStage 0 (PairwiseRDD[3] at reduceByKey at <stdin>:1)
15/10/05 14:02:36 INFO TaskSchedulerImpl: Adding task set 0.0 with 2 tasks
15/10/05 14:02:36 INFO TaskSetManager: Starting task 0.0 in stage 0.0 (TID 0, localhost, PROCESS_LOCAL, 2266 bytes)
15/10/05 14:02:36 INFO TaskSetManager: Starting task 1.0 in stage 0.0 (TID 1, localhost, PROCESS_LOCAL, 2266 bytes)
15/10/05 14:02:36 INFO Executor: Running task 0.0 in stage 0.0 (TID 0)
15/10/05 14:02:36 INFO Executor: Running task 1.0 in stage 0.0 (TID 1)
15/10/05 14:02:36 INFO Executor: Fetching http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar with timestamp 1444078954103
15/10/05 14:02:36 INFO Utils: Fetching http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar to /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/userFiles-d0940846-b38a-4e4d-af07-8419b364d7ff/fetchFileTemp476551478197543813.tmp
15/10/05 14:02:36 INFO Executor: Adding file:/private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/userFiles-d0940846-b38a-4e4d-af07-8419b364d7ff/livy-assembly-3.9.0-SNAPSHOT.jar to class loader
15/10/05 14:02:36 INFO HadoopRDD: Input split: file:/Users/huetest/Downloads/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv:0+8609511
15/10/05 14:02:36 INFO HadoopRDD: Input split: file:/Users/huetest/Downloads/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv:8609511+8609511
15/10/05 14:02:36 INFO deprecation: mapred.tip.id is deprecated. Instead, use mapreduce.task.id
15/10/05 14:02:36 INFO deprecation: mapred.task.id is deprecated. Instead, use mapreduce.task.attempt.id
15/10/05 14:02:36 INFO deprecation: mapred.task.is.map is deprecated. Instead, use mapreduce.task.ismap
15/10/05 14:02:36 INFO deprecation: mapred.task.partition is deprecated. Instead, use mapreduce.task.partition
15/10/05 14:02:36 INFO deprecation: mapred.job.id is deprecated. Instead, use mapreduce.job.id
15/10/05 14:02:37 INFO PythonRDD: Times: total = 727, boot = 229, init = 44, finish = 454
15/10/05 14:02:37 INFO PythonRDD: Times: total = 730, boot = 226, init = 46, finish = 458
15/10/05 14:02:37 INFO Executor: Finished task 1.0 in stage 0.0 (TID 1). 2318 bytes result sent to driver
15/10/05 14:02:37 INFO Executor: Finished task 0.0 in stage 0.0 (TID 0). 2318 bytes result sent to driver
15/10/05 14:02:37 INFO TaskSetManager: Finished task 1.0 in stage 0.0 (TID 1) in 950 ms on localhost (1/2)
15/10/05 14:02:37 INFO TaskSetManager: Finished task 0.0 in stage 0.0 (TID 0) in 962 ms on localhost (2/2)
15/10/05 14:02:37 INFO TaskSchedulerImpl: Removed TaskSet 0.0, whose tasks have all completed, from pool
15/10/05 14:02:37 INFO DAGScheduler: ShuffleMapStage 0 (reduceByKey at <stdin>:1) finished in 0.973 s
15/10/05 14:02:37 INFO DAGScheduler: looking for newly runnable stages
"""
LIVY_YARN_LOG = """
15/10/05 13:51:21 INFO client.RMProxy: Connecting to ResourceManager at huetest-1.test.com/175.18.213.12:8032
15/10/05 13:51:21 INFO yarn.Client: Requesting a new application from cluster with 3 NodeManagers
15/10/05 13:51:21 INFO yarn.Client: Verifying our application has not requested more than the maximum memory capability of the cluster (2048 MB per container)
15/10/05 13:51:21 INFO yarn.Client: Will allocate AM container, with 1408 MB memory including 384 MB overhead
15/10/05 13:51:21 INFO yarn.Client: Setting up container launch context for our AM
15/10/05 13:51:21 INFO yarn.Client: Setting up the launch environment for our AM container
15/10/05 13:51:21 INFO yarn.Client: Preparing resources for our AM container
15/10/05 13:51:21 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
15/10/05 13:51:21 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/lib/spark-assembly-1.5.0-hadoop2.6.0.jar -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/spark-assembly-1.5.0-hadoop2.6.0.jar
15/10/05 13:52:00 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/hue/apps/spark/java/livy-assembly/target/scala-2.10/livy-assembly-3.9.0-SNAPSHOT.jar -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/livy-assembly-3.9.0-SNAPSHOT.jar
15/10/05 13:52:09 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/python/lib/pyspark.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/pyspark.zip
15/10/05 13:52:09 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/python/lib/py4j-0.8.2.1-src.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/py4j-0.8.2.1-src.zip
15/10/05 13:52:10 INFO yarn.Client: Uploading resource file:/private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-3bde33db-374c-4abe-a4af-704bd5dc09d2/__spark_conf__4420686202746650998.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/__spark_conf__4420686202746650998.zip
15/10/05 13:52:10 INFO spark.SecurityManager: Changing view acls to: huetest
15/10/05 13:52:10 INFO spark.SecurityManager: Changing modify acls to: huetest
15/10/05 13:52:10 INFO spark.SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(huetest); users with modify permissions: Set(huetest)
15/10/05 13:52:10 INFO yarn.Client: Submitting application 2 to ResourceManager
15/10/05 13:52:10 INFO impl.YarnClientImpl: Submitted application application_1444070328046_0002
15/10/05 13:52:11 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:11 INFO yarn.Client:
client token: N/A
diagnostics: N/A
ApplicationMaster host: N/A
ApplicationMaster RPC port: -1
queue: root.huetest
start time: 1444078329419
final status: UNDEFINED
tracking URL: http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/
user: huetest
15/10/05 13:52:12 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:13 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:14 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:16 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:17 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:18 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:19 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:20 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:21 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:22 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:23 INFO yarn.Client: Application report for application_1444070328046_0002 (state: RUNNING)
15/10/05 13:52:23 INFO yarn.Client:
client token: N/A
diagnostics: N/A
ApplicationMaster host: 175.18.213.12
ApplicationMaster RPC port: 0
queue: root.huetest
start time: 1444078329419
final status: UNDEFINED
tracking URL: http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/
user: huetest
15/10/05 13:52:24 INFO yarn.Client: Application report for application_1444070328046_0002 (state: RUNNING)
"""
def setUp(self):
self.user = '******'
self.api = SparkApi(self.user)
def test_get_jobs(self):
local_jobs = [{
'url': u'http://172.21.1.246:4040/jobs/job/?id=0',
'name': u'0'
}]
jobs = self.api._get_standalone_jobs(self.LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [{
'url':
u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/',
'name': u'application_1444070328046_0002'
}]
jobs = self.api._get_yarn_jobs(self.LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)
class TestSparkShellConnector(object):
LIVY_STANDALONE_LOG = """
Starting livy-repl on http://172.21.1.246:58449
Using Spark's default log4j profile: org/apache/spark/log4j-defaults.properties
15/10/05 14:02:33 INFO SparkContext: Running Spark version 1.5.0
15/10/05 14:02:33 INFO SecurityManager: Changing view acls to: huetest
15/10/05 14:02:33 INFO SecurityManager: Changing modify acls to: huetest
15/10/05 14:02:33 INFO SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(huetest); users with modify permissions: Set(huetest)
15/10/05 14:02:33 INFO Slf4jLogger: Slf4jLogger started
15/10/05 14:02:33 INFO Remoting: Starting remoting
15/10/05 14:02:33 INFO Remoting: Remoting started; listening on addresses :[akka.tcp://[email protected]:58451]
15/10/05 14:02:33 INFO Utils: Successfully started service 'sparkDriver' on port 58451.
15/10/05 14:02:33 INFO SparkEnv: Registering MapOutputTracker
15/10/05 14:02:33 INFO SparkEnv: Registering BlockManagerMaster
15/10/05 14:02:33 INFO DiskBlockManager: Created local directory at /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/blockmgr-f63fdd28-6d86-4ae6-a91c-902fb0310fb4
15/10/05 14:02:33 INFO MemoryStore: MemoryStore started with capacity 530.0 MB
15/10/05 14:02:33 INFO HttpFileServer: HTTP File server directory is /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/httpd-0235b01f-ee8b-40fd-96a9-de946b1a3426
15/10/05 14:02:33 INFO HttpServer: Starting HTTP Server
15/10/05 14:02:33 INFO Utils: Successfully started service 'HTTP file server' on port 58452.
15/10/05 14:02:33 INFO SparkEnv: Registering OutputCommitCoordinator
15/10/05 14:02:33 INFO Utils: Successfully started service 'SparkUI' on port 4040.
15/10/05 14:02:33 INFO SparkUI: Started SparkUI at http://172.21.1.246:4040
15/10/05 14:02:34 INFO SparkContext: Added JAR file:/Users/huetest/Dev/hue/apps/spark/java/livy-assembly/target/scala-2.10/livy-assembly-3.9.0-SNAPSHOT.jar at http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar with timestamp 1444078954103
15/10/05 14:02:34 WARN MetricsSystem: Using default name DAGScheduler for source because spark.app.id is not set.
15/10/05 14:02:34 INFO Executor: Starting executor ID driver on host localhost
15/10/05 14:02:34 INFO Utils: Successfully started service 'org.apache.spark.network.netty.NettyBlockTransferService' on port 58453.
15/10/05 14:02:34 INFO NettyBlockTransferService: Server created on 58453
15/10/05 14:02:34 INFO BlockManagerMaster: Trying to register BlockManager
15/10/05 14:02:34 INFO BlockManagerMasterEndpoint: Registering block manager localhost:58453 with 530.0 MB RAM, BlockManagerId(driver, localhost, 58453)
15/10/05 14:02:34 INFO BlockManagerMaster: Registered BlockManager
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(130448) called with curMem=0, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_0 stored as values in memory (estimated size 127.4 KB, free 529.9 MB)
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(14276) called with curMem=130448, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_0_piece0 stored as bytes in memory (estimated size 13.9 KB, free 529.9 MB)
15/10/05 14:02:36 INFO BlockManagerInfo: Added broadcast_0_piece0 in memory on localhost:58453 (size: 13.9 KB, free: 530.0 MB)
15/10/05 14:02:36 INFO SparkContext: Created broadcast 0 from textFile at NativeMethodAccessorImpl.java:-2
15/10/05 14:02:36 INFO FileInputFormat: Total input paths to process : 1
15/10/05 14:02:36 INFO SparkContext: Starting job: collect at <stdin>:1
15/10/05 14:02:36 INFO DAGScheduler: Registering RDD 3 (reduceByKey at <stdin>:1)
15/10/05 14:02:36 INFO DAGScheduler: Registering RDD 7 (combineByKey at <stdin>:3)
15/10/05 14:02:36 INFO DAGScheduler: Got job 0 (collect at <stdin>:1) with 2 output partitions
15/10/05 14:02:36 INFO DAGScheduler: Final stage: ResultStage 2(collect at <stdin>:1)
15/10/05 14:02:36 INFO DAGScheduler: Parents of final stage: List(ShuffleMapStage 1)
15/10/05 14:02:36 INFO DAGScheduler: Missing parents: List(ShuffleMapStage 1)
15/10/05 14:02:36 INFO DAGScheduler: Submitting ShuffleMapStage 0 (PairwiseRDD[3] at reduceByKey at <stdin>:1), which has no missing parents
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(8960) called with curMem=144724, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_1 stored as values in memory (estimated size 8.8 KB, free 529.9 MB)
15/10/05 14:02:36 INFO MemoryStore: ensureFreeSpace(5483) called with curMem=153684, maxMem=555755765
15/10/05 14:02:36 INFO MemoryStore: Block broadcast_1_piece0 stored as bytes in memory (estimated size 5.4 KB, free 529.9 MB)
15/10/05 14:02:36 INFO BlockManagerInfo: Added broadcast_1_piece0 in memory on localhost:58453 (size: 5.4 KB, free: 530.0 MB)
15/10/05 14:02:36 INFO SparkContext: Created broadcast 1 from broadcast at DAGScheduler.scala:861
15/10/05 14:02:36 INFO DAGScheduler: Submitting 2 missing tasks from ShuffleMapStage 0 (PairwiseRDD[3] at reduceByKey at <stdin>:1)
15/10/05 14:02:36 INFO TaskSchedulerImpl: Adding task set 0.0 with 2 tasks
15/10/05 14:02:36 INFO TaskSetManager: Starting task 0.0 in stage 0.0 (TID 0, localhost, PROCESS_LOCAL, 2266 bytes)
15/10/05 14:02:36 INFO TaskSetManager: Starting task 1.0 in stage 0.0 (TID 1, localhost, PROCESS_LOCAL, 2266 bytes)
15/10/05 14:02:36 INFO Executor: Running task 0.0 in stage 0.0 (TID 0)
15/10/05 14:02:36 INFO Executor: Running task 1.0 in stage 0.0 (TID 1)
15/10/05 14:02:36 INFO Executor: Fetching http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar with timestamp 1444078954103
15/10/05 14:02:36 INFO Utils: Fetching http://172.21.1.246:58452/jars/livy-assembly-3.9.0-SNAPSHOT.jar to /private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/userFiles-d0940846-b38a-4e4d-af07-8419b364d7ff/fetchFileTemp476551478197543813.tmp
15/10/05 14:02:36 INFO Executor: Adding file:/private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-a0e35333-e2be-4b83-8a7e-3cb468270dc2/userFiles-d0940846-b38a-4e4d-af07-8419b364d7ff/livy-assembly-3.9.0-SNAPSHOT.jar to class loader
15/10/05 14:02:36 INFO HadoopRDD: Input split: file:/Users/huetest/Downloads/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv:0+8609511
15/10/05 14:02:36 INFO HadoopRDD: Input split: file:/Users/huetest/Downloads/babs_open_data_year_1/201402_babs_open_data/201402_trip_data.csv:8609511+8609511
15/10/05 14:02:36 INFO deprecation: mapred.tip.id is deprecated. Instead, use mapreduce.task.id
15/10/05 14:02:36 INFO deprecation: mapred.task.id is deprecated. Instead, use mapreduce.task.attempt.id
15/10/05 14:02:36 INFO deprecation: mapred.task.is.map is deprecated. Instead, use mapreduce.task.ismap
15/10/05 14:02:36 INFO deprecation: mapred.task.partition is deprecated. Instead, use mapreduce.task.partition
15/10/05 14:02:36 INFO deprecation: mapred.job.id is deprecated. Instead, use mapreduce.job.id
15/10/05 14:02:37 INFO PythonRDD: Times: total = 727, boot = 229, init = 44, finish = 454
15/10/05 14:02:37 INFO PythonRDD: Times: total = 730, boot = 226, init = 46, finish = 458
15/10/05 14:02:37 INFO Executor: Finished task 1.0 in stage 0.0 (TID 1). 2318 bytes result sent to driver
15/10/05 14:02:37 INFO Executor: Finished task 0.0 in stage 0.0 (TID 0). 2318 bytes result sent to driver
15/10/05 14:02:37 INFO TaskSetManager: Finished task 1.0 in stage 0.0 (TID 1) in 950 ms on localhost (1/2)
15/10/05 14:02:37 INFO TaskSetManager: Finished task 0.0 in stage 0.0 (TID 0) in 962 ms on localhost (2/2)
15/10/05 14:02:37 INFO TaskSchedulerImpl: Removed TaskSet 0.0, whose tasks have all completed, from pool
15/10/05 14:02:37 INFO DAGScheduler: ShuffleMapStage 0 (reduceByKey at <stdin>:1) finished in 0.973 s
15/10/05 14:02:37 INFO DAGScheduler: looking for newly runnable stages
"""
LIVY_YARN_LOG = """
15/10/05 13:51:21 INFO client.RMProxy: Connecting to ResourceManager at huetest-1.test.com/175.18.213.12:8032
15/10/05 13:51:21 INFO yarn.Client: Requesting a new application from cluster with 3 NodeManagers
15/10/05 13:51:21 INFO yarn.Client: Verifying our application has not requested more than the maximum memory capability of the cluster (2048 MB per container)
15/10/05 13:51:21 INFO yarn.Client: Will allocate AM container, with 1408 MB memory including 384 MB overhead
15/10/05 13:51:21 INFO yarn.Client: Setting up container launch context for our AM
15/10/05 13:51:21 INFO yarn.Client: Setting up the launch environment for our AM container
15/10/05 13:51:21 INFO yarn.Client: Preparing resources for our AM container
15/10/05 13:51:21 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
15/10/05 13:51:21 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/lib/spark-assembly-1.5.0-hadoop2.6.0.jar -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/spark-assembly-1.5.0-hadoop2.6.0.jar
15/10/05 13:52:00 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/hue/apps/spark/java/livy-assembly/target/scala-2.10/livy-assembly-3.9.0-SNAPSHOT.jar -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/livy-assembly-3.9.0-SNAPSHOT.jar
15/10/05 13:52:09 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/python/lib/pyspark.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/pyspark.zip
15/10/05 13:52:09 INFO yarn.Client: Uploading resource file:/Users/huetest/Dev/spark-1.5.0-bin-hadoop2.6/python/lib/py4j-0.8.2.1-src.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/py4j-0.8.2.1-src.zip
15/10/05 13:52:10 INFO yarn.Client: Uploading resource file:/private/var/folders/7t/31vfhhq92_g628vh8q5pspbc0000gp/T/spark-3bde33db-374c-4abe-a4af-704bd5dc09d2/__spark_conf__4420686202746650998.zip -> hdfs://huetest-1.vpc.cloudera.com:8020/user/huetest/.sparkStaging/application_1444070328046_0002/__spark_conf__4420686202746650998.zip
15/10/05 13:52:10 INFO spark.SecurityManager: Changing view acls to: huetest
15/10/05 13:52:10 INFO spark.SecurityManager: Changing modify acls to: huetest
15/10/05 13:52:10 INFO spark.SecurityManager: SecurityManager: authentication disabled; ui acls disabled; users with view permissions: Set(huetest); users with modify permissions: Set(huetest)
15/10/05 13:52:10 INFO yarn.Client: Submitting application 2 to ResourceManager
15/10/05 13:52:10 INFO impl.YarnClientImpl: Submitted application application_1444070328046_0002
15/10/05 13:52:11 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:11 INFO yarn.Client:
client token: N/A
diagnostics: N/A
ApplicationMaster host: N/A
ApplicationMaster RPC port: -1
queue: root.huetest
start time: 1444078329419
final status: UNDEFINED
tracking URL: http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/
user: huetest
15/10/05 13:52:12 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:13 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:14 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:16 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:17 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:18 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:19 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:20 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:21 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:22 INFO yarn.Client: Application report for application_1444070328046_0002 (state: ACCEPTED)
15/10/05 13:52:23 INFO yarn.Client: Application report for application_1444070328046_0002 (state: RUNNING)
15/10/05 13:52:23 INFO yarn.Client:
client token: N/A
diagnostics: N/A
ApplicationMaster host: 175.18.213.12
ApplicationMaster RPC port: 0
queue: root.huetest
start time: 1444078329419
final status: UNDEFINED
tracking URL: http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/
user: huetest
15/10/05 13:52:24 INFO yarn.Client: Application report for application_1444070328046_0002 (state: RUNNING)
"""
def setUp(self):
self.user = '******'
self.api = SparkApi(self.user)
def test_get_jobs(self):
local_jobs = [
{'url': u'http://172.21.1.246:4040/jobs/job/?id=0', 'name': u'0'}
]
jobs = self.api._get_standalone_jobs(self.LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [
{'url': u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/', 'name': u'application_1444070328046_0002'}
]
jobs = self.api._get_yarn_jobs(self.LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)
class TestSparkApi(object):
def setUp(self):
self.user = '******'
self.interpreter = {
'name': 'livy',
'options': {
'api_url': 'http://gethue.com:8998'
},
}
self.api = SparkApi(self.user, self.interpreter)
def test_get_api(self):
lang = 'pyspark'
properties = None
# with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
spark_api = self.api.get_api()
assert_equal(spark_api.__class__.__name__, 'LivyClient')
def test_get_livy_props_method(self):
test_properties = [{
"name": "files",
"value": 'file_a,file_b,file_c',
}]
props = self.api.get_livy_props('scala', test_properties)
assert_equal(props['files'], ['file_a', 'file_b', 'file_c'])
def test_create_session_with_config(self):
lang = 'pyspark'
properties = None
session_key = self.api._get_session_key()
with patch('notebook.connectors.spark_shell.get_spark_api'
) as get_spark_api:
with patch('notebook.connectors.spark_shell.DefaultConfiguration'
) as DefaultConfiguration:
with patch(
'notebook.connectors.spark_shell.USE_DEFAULT_CONFIGURATION'
) as USE_DEFAULT_CONFIGURATION:
DefaultConfiguration.objects.get_configuration_for_user.return_value = Mock(
properties_list=[{
'multiple': False,
'name': 'driverCores',
'defaultValue': 1,
'value': 2,
'nice_name': 'Driver Cores',
'help_text':
'Number of cores used by the driver, only in cluster mode (Default: 1)',
'type': 'number',
'is_yarn': True
}])
get_spark_api.return_value = Mock(
create_session=Mock(return_value={'id': '1'}),
get_session=Mock(return_value={
'state': 'idle',
'log': ''
}))
# Case with user configuration. Expected 2 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
session = self.api.create_session(lang=lang,
properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
for p in session['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 2)
if SESSIONS.get(session_key):
del SESSIONS[session_key]
# Case without user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
DefaultConfiguration.objects.get_configuration_for_user.return_value = None
session2 = self.api.create_session(lang=lang,
properties=properties)
assert_equal(session2['type'], 'pyspark')
assert_equal(session2['id'], '1')
for p in session2['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
if SESSIONS.get(session_key):
del SESSIONS[session_key]
# Case with no user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = False
session3 = self.api.create_session(lang=lang,
properties=properties)
assert_equal(session3['type'], 'pyspark')
assert_equal(session3['id'], '1')
for p in session3['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
if SESSIONS.get(session_key):
del SESSIONS[session_key]
def test_create_session_plain(self):
lang = 'pyspark'
properties = None
session_key = self.api._get_session_key()
with patch('notebook.connectors.spark_shell.get_spark_api'
) as get_spark_api:
get_spark_api.return_value = Mock(
create_session=Mock(return_value={'id': '1'}),
get_session=Mock(return_value={
'state': 'idle',
'log': ''
}))
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
files_properties = [
prop for prop in session['properties']
if prop['name'] == 'files'
]
assert_true(files_properties, session['properties'])
assert_equal(files_properties[0]['value'], [],
session['properties'])
if SESSIONS.get(session_key):
del SESSIONS[session_key]
def test_execute(self):
with patch('notebook.connectors.spark_shell._get_snippet_session'
) as _get_snippet_session:
with patch('notebook.connectors.spark_shell.get_spark_api'
) as get_spark_api:
notebook = Mock()
snippet = {'statement': 'select * from test_table'}
_get_snippet_session.return_value = {'id': '1'}
get_spark_api.return_value = Mock(submit_statement=Mock(
return_value={'id': 'test_id'}))
response = self.api.execute(notebook, snippet)
assert_equal(response['id'], 'test_id')
get_spark_api.return_value = Mock(submit_statement=Mock())
assert_raises(Exception, self.api.execute, notebook, snippet)
def test_check_status(self):
with patch('notebook.connectors.spark_shell._get_snippet_session'
) as _get_snippet_session:
with patch('notebook.connectors.spark_shell.get_spark_api'
) as get_spark_api:
notebook = Mock()
snippet = {'result': {'handle': {'id': {'test_id'}}}}
_get_snippet_session.return_value = {'id': '1'}
get_spark_api.return_value = Mock(fetch_data=Mock(
return_value={'state': 'test_state'}))
response = self.api.check_status(notebook, snippet)
assert_equal(response['status'], 'test_state')
get_spark_api.return_value = Mock(submit_statement=Mock())
assert_raises(Exception, self.api.check_status, notebook,
snippet)
def test_get_sample_data(self):
snippet = Mock()
self.api._execute = Mock(return_value='test_value')
self.api._check_status_and_fetch_result = Mock(return_value={
'data': 'test_data',
'meta': 'test_meta'
})
response = self.api.get_sample_data(snippet, 'test_db', 'test_table',
'test_column')
assert_equal(response['rows'], 'test_data')
assert_equal(response['full_headers'], 'test_meta')
def test_get_select_query(self):
# With operation as 'hello'
response = self.api._get_select_query('test_db', 'test_table',
'test_column', 'hello')
assert_equal(response, "SELECT 'Hello World!'")
# Without column name
response = self.api._get_select_query('test_db', 'test_table')
assert_equal(response,
'SELECT *\nFROM test_db.test_table\nLIMIT 100\n')
# With some column name
response = self.api._get_select_query('test_db', 'test_table',
'test_column')
assert_equal(
response,
'SELECT test_column\nFROM test_db.test_table\nLIMIT 100\n')
def test_get_jobs(self):
local_jobs = [{
'url': u'http://172.21.1.246:4040/jobs/job/?id=0',
'name': u'0'
}]
jobs = self.api._get_standalone_jobs(LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [{
'url':
u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/',
'name': u'application_1444070328046_0002'
}]
jobs = self.api._get_yarn_jobs(LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)
class TestSparkApi(object):
def setUp(self):
self.client = make_logged_in_client(username="******", groupname="default", recreate=True, is_superuser=False)
self.user = User.objects.get(username="******")
self.interpreter = {
'name': 'livy',
'options': {
'api_url': 'http://gethue.com:8998'
},
}
self.api = SparkApi(self.user, self.interpreter)
def test_get_api(self):
lang = 'pyspark'
properties = None
# with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
spark_api = self.api.get_api()
assert_equal(spark_api.__class__.__name__, 'LivyClient')
def test_get_livy_props_method(self):
test_properties = [{
"name": "files",
"value": 'file_a,file_b,file_c',
}]
props = self.api.get_livy_props('scala', test_properties)
assert_equal(props['files'], ['file_a', 'file_b', 'file_c'])
def test_create_session_with_config(self):
lang = 'pyspark'
properties = None
session_key = self.api._get_session_key()
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
with patch('notebook.connectors.spark_shell.DefaultConfiguration') as DefaultConfiguration:
with patch('notebook.connectors.spark_shell.USE_DEFAULT_CONFIGURATION') as USE_DEFAULT_CONFIGURATION:
DefaultConfiguration.objects.get_configuration_for_user.return_value = Mock(
properties_list=[
{'multiple': False, 'name': 'driverCores', 'defaultValue': 1, 'value': 2, 'nice_name': 'Driver Cores',
'help_text': 'Number of cores used by the driver, only in cluster mode (Default: 1)', 'type': 'number',
'is_yarn': True}]
)
get_spark_api.return_value = Mock(
create_session=Mock(
return_value={'id': '1'}
),
get_session=Mock(
return_value={'state': 'idle', 'log': ''}
)
)
# Case with user configuration. Expected 2 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
for p in session['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 2)
if self.api._get_session_info_from_user():
self.api._remove_session_info_from_user()
# Case without user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = True
DefaultConfiguration.objects.get_configuration_for_user.return_value = None
session2 = self.api.create_session(lang=lang, properties=properties)
assert_equal(session2['type'], 'pyspark')
assert_equal(session2['id'], '1')
for p in session2['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
# Case with no user configuration. Expected 1 driverCores
USE_DEFAULT_CONFIGURATION.get.return_value = False
session3 = self.api.create_session(lang=lang, properties=properties)
assert_equal(session3['type'], 'pyspark')
assert_equal(session3['id'], '1')
for p in session3['properties']:
if p['name'] == 'driverCores':
cores = p['value']
assert_equal(cores, 1)
def test_create_session_plain(self):
lang = 'pyspark'
properties = None
session_key = self.api._get_session_key()
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
get_spark_api.return_value = Mock(
create_session=Mock(
return_value={'id': '1'}
),
get_session=Mock(
return_value={'state': 'idle', 'log': ''}
)
)
session = self.api.create_session(lang=lang, properties=properties)
assert_equal(session['type'], 'pyspark')
assert_equal(session['id'], '1')
files_properties = [prop for prop in session['properties'] if prop['name'] == 'files']
assert_true(files_properties, session['properties'])
assert_equal(files_properties[0]['value'], [], session['properties'])
def test_execute(self):
with patch('notebook.connectors.spark_shell._get_snippet_session') as _get_snippet_session:
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
notebook = Mock()
snippet = {'statement': 'select * from test_table'}
_get_snippet_session.return_value = {'id': '1'}
get_spark_api.return_value = Mock(
submit_statement=Mock(
return_value={'id': 'test_id'}
)
)
self.api._check_session = Mock(return_value={'id': '1'})
response = self.api.execute(notebook, snippet)
assert_equal(response['id'], 'test_id')
get_spark_api.return_value = Mock(
submit_statement=Mock()
)
assert_raises(Exception, self.api.execute, notebook, snippet)
def test_check_status(self):
with patch('notebook.connectors.spark_shell._get_snippet_session') as _get_snippet_session:
with patch('notebook.connectors.spark_shell.get_spark_api') as get_spark_api:
notebook = Mock()
snippet = {
'result': {
'handle': {
'id': {'test_id'}
}
}
}
_get_snippet_session.return_value = {'id': '1'}
get_spark_api.return_value = Mock(
fetch_data=Mock(
return_value={'state': 'test_state'}
)
)
self.api._handle_session_health_check = Mock(return_value={'id': '1'})
response = self.api.check_status(notebook, snippet)
assert_equal(response['status'], 'test_state')
get_spark_api.return_value = Mock(
submit_statement=Mock()
)
assert_raises(Exception, self.api.check_status, notebook, snippet)
def test_get_sample_data(self):
snippet = Mock()
self.api._execute = Mock(
return_value='test_value'
)
self.api.create_session = Mock(
return_value={
'id': 'test_id'
}
)
self.api._check_status_and_fetch_result = Mock(
return_value={
'data': 'test_data',
'meta': 'test_meta'
}
)
# When table is transactional
self.api.describe_table = Mock(
return_value={
'stats': [{
'data_type': 'transactional',
'col_name': 'true',
'comment': ''
}]
}
)
response = self.api.get_sample_data(snippet, 'test_db', 'test_table', 'test_column')
assert_equal(response['rows'], [])
assert_equal(response['full_headers'], [])
# When table is not transactional
self.api.describe_table = Mock(
return_value={
'stats': [] # No details regarding transactionality is present in describe response
}
)
response = self.api.get_sample_data(snippet, 'test_db', 'test_table', 'test_column')
assert_equal(response['rows'], 'test_data')
assert_equal(response['full_headers'], 'test_meta')
def test_get_select_query(self):
# With operation as 'hello'
response = self.api._get_select_query('test_db', 'test_table', 'test_column', 'hello')
assert_equal(response, "SELECT 'Hello World!'")
# Without column name
response = self.api._get_select_query('test_db', 'test_table')
assert_equal(response, 'SELECT *\nFROM test_db.test_table\nLIMIT 100\n')
# With some column name
response = self.api._get_select_query('test_db', 'test_table', 'test_column')
assert_equal(response, 'SELECT test_column\nFROM test_db.test_table\nLIMIT 100\n')
def test_describe_database(self):
notebook = Mock()
snippet = Mock()
self.api.create_session = Mock(
return_value={
'id': 'test_id'
}
)
self.api._execute = Mock(
return_value='test_value'
)
self.api._check_status_and_fetch_result = Mock(
return_value={
'data': [
['Namespace Name', 'employees'],
['Comment', 'For software companies'],
['Location', 'hdfs://test_url:8020/warehouse/tablespace/external/hive/employees.db'],
['Owner', 'demo'],
['Properties', '((Create-by,Kevin), (Create-date,09/01/2019))']],
'images': [],
'meta': [
{'comment': '', 'name': 'info_name', 'type': 'string'},
{'comment': '', 'name': 'info_value', 'type': 'string'}],
'type': 'table'}
)
response = self.api.describe_database(notebook, snippet, 'employees')
assert_equal(response, {
'comment': 'For software companies',
'db_name': 'employees',
'location': 'hdfs://test_url:8020/warehouse/tablespace/external/hive/employees.db',
'owner_name': 'demo',
'parameters': '{Create-by=Kevin, Create-date=09/01/2019}',
'status': 0})
def test_describe_table(self):
notebook = Mock()
snippet = Mock()
self.api.create_session = Mock(
return_value={
'id': 'test_id'
}
)
self.api._execute = Mock(
return_value='test_value'
)
self.api._check_status_and_fetch_result = Mock(
return_value={
'data': [
['nname', 'string', None],
['# Partition Information', '', ''],
['# col_name', 'data_type', 'comment'],
['state', 'string', 'null'],
['', '', ''],
['# Detailed Table Information', '', ''],
['Database', 'default', ''],
['Table', 'test_nonacid', ''],
['Owner', 'demo', ''],
['Created Time', 'Tue Jun 28 11:35:33 UTC 2022', ''],
['Last Access', 'UNKNOWN', ''],
['Created By', 'Spark 3.3.0.7.2.16.0-94', ''],
['Type', 'EXTERNAL', ''],
['Provider', 'hive', ''],
['Table Properties',
'[TRANSLATED_TO_EXTERNAL=TRUE, bucketing_version=2, '
'external.table.purge=TRUE, numFilesErasureCoded=0, '
'transient_lastDdlTime=1656416152]',
''],
['Statistics', '6 bytes', ''],
['Location',
'hdfs://test_url:8020/warehouse/tablespace/external/hive/test_nonacid',
''],
['Serde Library',
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe',
''],
['InputFormat', 'org.apache.hadoop.mapred.TextInputFormat', ''],
['OutputFormat',
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',
''],
['Storage Properties', '[serialization.format=1]', ''],
['Partition Provider', 'Catalog', '']],
'images': [],
'meta': [
{'comment': '', 'name': 'col_name', 'type': 'string'},
{'comment': '', 'name': 'data_type', 'type': 'string'},
{'comment': '', 'name': 'comment', 'type': 'string'}],
'type': 'table'
}
)
response = self.api.describe_table(notebook, snippet, 'default', 'test_nonacid')
assert_equal(response, {
'cols': [{'comment': 'None', 'name': 'nname', 'type': 'string'}],
'comment': '',
'details': {'properties': {
'create_time': 'Tue Jun 28 11:35:33 UTC 2022',
'format': 'text',
'owner': 'demo',
'table_type': 'EXTERNAL'},
'stats': [
{
'col_name': 'TRUE',
'comment': '',
'data_type': 'TRANSLATED_TO_EXTERNAL'},
{
'col_name': '2',
'comment': '',
'data_type': 'bucketing_version'},
{
'col_name': 'TRUE',
'comment': '',
'data_type': 'external.table.purge'},
{
'col_name': '0',
'comment': '',
'data_type': 'numFilesErasureCoded'},
{
'col_name': '1656416152',
'comment': '',
'data_type': 'transient_lastDdlTime'}]},
'hdfs_link': '/filebrowser/view=/warehouse/tablespace/external/hive/test_nonacid',
'is_view': False,
'name': 'test_nonacid',
'partition_keys': [{'name': 'state', 'type': 'string'}],
'path_location': 'hdfs://test_url:8020/warehouse/tablespace/external/hive/test_nonacid',
'primary_keys': [],
'properties': [{'col_name': '# Partition Information',
'comment': '',
'data_type': ''},
{'col_name': '# col_name',
'comment': 'comment',
'data_type': 'data_type'},
{'col_name': 'state', 'comment': 'null', 'data_type': 'string'},
{'col_name': '', 'comment': '', 'data_type': ''},
{'col_name': '# Detailed Table Information',
'comment': '',
'data_type': ''},
{'col_name': 'Database', 'comment': '', 'data_type': 'default'},
{'col_name': 'Table',
'comment': '',
'data_type': 'test_nonacid'},
{'col_name': 'Owner', 'comment': '', 'data_type': 'demo'},
{'col_name': 'Created Time',
'comment': '',
'data_type': 'Tue Jun 28 11:35:33 UTC 2022'},
{'col_name': 'Last Access',
'comment': '',
'data_type': 'UNKNOWN'},
{'col_name': 'Created By',
'comment': '',
'data_type': 'Spark 3.3.0.7.2.16.0-94'},
{'col_name': 'Type', 'comment': '', 'data_type': 'EXTERNAL'},
{'col_name': 'Provider', 'comment': '', 'data_type': 'hive'},
{'col_name': 'Table Properties',
'comment': '',
'data_type': '[TRANSLATED_TO_EXTERNAL=TRUE, '
'bucketing_version=2, external.table.purge=TRUE, '
'numFilesErasureCoded=0, '
'transient_lastDdlTime=1656416152]'},
{'col_name': 'Statistics',
'comment': '',
'data_type': '6 bytes'},
{'col_name': 'Location',
'comment': '',
'data_type': 'hdfs://test_url:8020/warehouse/tablespace/external/hive/test_nonacid'},
{'col_name': 'Serde Library',
'comment': '',
'data_type': 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'},
{'col_name': 'InputFormat',
'comment': '',
'data_type': 'org.apache.hadoop.mapred.TextInputFormat'},
{'col_name': 'OutputFormat',
'comment': '',
'data_type': 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'},
{'col_name': 'Storage Properties',
'comment': '',
'data_type': '[serialization.format=1]'},
{'col_name': 'Partition Provider',
'comment': '',
'data_type': 'Catalog'}],
'stats': [{'col_name': 'TRUE',
'comment': '',
'data_type': 'TRANSLATED_TO_EXTERNAL'},
{'col_name': '2', 'comment': '', 'data_type': 'bucketing_version'},
{'col_name': 'TRUE',
'comment': '',
'data_type': 'external.table.purge'},
{'col_name': '0',
'comment': '',
'data_type': 'numFilesErasureCoded'},
{'col_name': '1656416152',
'comment': '',
'data_type': 'transient_lastDdlTime'}],
'status': 0})
def test_get_jobs(self):
local_jobs = [
{'url': u'http://172.21.1.246:4040/jobs/job/?id=0', 'name': u'0'}
]
jobs = self.api._get_standalone_jobs(LIVY_STANDALONE_LOG)
assert_equal(jobs, local_jobs, jobs)
yarn_jobs = [
{'url': u'http://huetest-1.test.com:8088/proxy/application_1444070328046_0002/', 'name': u'application_1444070328046_0002'}
]
jobs = self.api._get_yarn_jobs(LIVY_YARN_LOG)
assert_equal(jobs, yarn_jobs, jobs)