[SPARK-16236][SQL][FOLLOWUP] Add Path Option back to Load API in DataFrameReader
[SPARK-16236][SQL][FOLLOWUP] Add Path Option back to Load API in DataFrameReader

#### What changes were proposed in this pull request?
In Python API, we have the same issue. Thanks for identifying this issue, zsxwing ! Below is an example:
```Python
spark.read.format('json').load('python/test_support/sql/people.json')
```
#### How was this patch tested?
Existing test cases cover the changes by this PR

Author: gatorsmile <gatorsmile@gmail.com>

Closes #13965 from gatorsmile/optionPaths.

stanzhai/spark,jkbradley/spark,maropu/spark,akopich/spark,shaneknapp/spark,patrick-nicholson/spark,pgandhi999/spark,rekhajoshm/spark,aosagie/spark,BryanCutler/spark,lvdongr/spark,ddna1021/spark,patrick-nicholson/spark,hvanhovell/spark,milliman/spark,stanzhai/spark,ibm-research-ireland/sparkoscope,narahari92/spark,nchammas/spark,srowen/spark,lxsmnv/spark,ddna1021/spark,xuanyuanking/spark,chuckchen/spark,JoshRosen/spark,guoxiaolongzte/spark,ueshin/apache-spark,janewangfb/spark,hhbyyh/spark,rikima/spark,publicRoman/spark,rekhajoshm/spark,zzcclp/spark,markhamstra/spark,zzcclp/spark,wangyum/spark,ericvandenbergfb/spark,mike0sv/spark,jiangxb1987/spark,aray/spark,rikima/spark,hhbyyh/spark,kiszk/spark,aray/spark,kevinyu98/spark,sachintyagi22/spark,michalsenkyr/spark,rezasafi/spark,nlalevee/spark,ConeyLiu/spark,taroplus/spark,maropu/spark,wangmiao1981/spark,JerryLead/spark,goldmedal/spark,someorz/spark,sachintyagi22/spark,ptkool/spark,sahilTakiar/spark,markhamstra/spark,panfengfeng/spark,alunarbeach/spark,xuanyuanking/spark,shubhamchopra/spark,nchammas/spark,joseph-torres/spark,adrian-ionescu/apache-spark,1haodian/spark,bdrillard/spark,rezasafi/spark,Panos-Bletsos/spark-cost-model-optimizer,srowen/spark,srowen/spark,taroplus/spark,srowen/spark,LantaoJin/spark,sureshthalamati/spark,michalsenkyr/spark,maropu/spark,skonto/spark,loneknightpy/spark,saltstar/spark,jkbradley/spark,techaddict/spark,srowen/spark,vinodkc/spark,apache/spark,jiangxb1987/spark,kiszk/spark,vinodkc/spark,hvanhovell/spark,apache-spark-on-k8s/spark,ericvandenbergfb/spark,nilsgrabbert/spark,WindCanDie/spark,panfengfeng/spark,LantaoJin/spark,JerryLead/spark,yanboliang/spark,kimoonkim/spark,ahnqirage/spark,narahari92/spark,nchammas/spark,alunarbeach/spark,highfei2011/spark,actuaryzhang/spark,ioana-delaney/spark,zzcclp/spark,aosagie/spark,caneGuy/spark,eyalfa/spark,mahak/spark,darionyaphet/spark,ptkool/spark,setjet/spark,big-pegasus/spark,WindCanDie/spark,dongjoon-hyun/spark,adrian-ionescu/apache-spark,kevinyu98/spark,ioana-delaney/spark,ptkool/spark,yanboliang/spark,rekhajoshm/spark,vinodkc/spark,byakuinss/spark,liyichao/spark,wzhfy/spark,poffuomo/spark,actuaryzhang/spark,szhem/spark,zhouyejoe/spark,rikima/spark,panfengfeng/spark,ddna1021/spark,mike0sv/spark,highfei2011/spark,kissmetrics/spark,kissmetrics/spark,zuotingbing/spark,xuanyuanking/spark,joseph-torres/spark,panfengfeng/spark,jiangxb1987/spark,JoshRosen/spark,zero323/spark,gengliangwang/spark,zuotingbing/spark,sachintyagi22/spark,janewangfb/spark,jianran/spark,loneknightpy/spark,shuangshuangwang/spark,xflin/spark,kevinyu98/spark,mzl9039/spark,chuckchen/spark,huang1900/spark,brad-kaiser/spark,sureshthalamati/spark,cin/spark,gengliangwang/spark,shubhamchopra/spark,saltstar/spark,aokolnychyi/spark,liutang123/spark,esi-mineset/spark,goldmedal/spark,dbtsai/spark,panfengfeng/spark,map222/spark,kiszk/spark,chuckchen/spark,milliman/spark,bdrillard/spark,vinodkc/spark,andrewor14/spark,gengliangwang/spark,shuangshuangwang/spark,SnappyDataInc/spark,mahak/spark,jrshust/spark,zuotingbing/spark,hvanhovell/spark,vinodkc/spark,tejasapatil/spark,zero323/spark,maropu/spark,mahak/spark,rednaxelafx/apache-spark,tejasapatil/spark,joseph-torres/spark,zero323/spark,WeichenXu123/spark,rikima/spark,Aegeaner/spark,wangmiao1981/spark,mdespriee/spark,dbtsai/spark,debugger87/spark,hhbyyh/spark,rednaxelafx/apache-spark,cloud-fan/spark,jianran/spark,icexelloss/spark,debugger87/spark,joseph-torres/spark,janewangfb/spark,rednaxelafx/apache-spark,spark-test/spark,ueshin/apache-spark,setjet/spark,wzhfy/spark,rezasafi/spark,ericvandenbergfb/spark,loneknightpy/spark,ioana-delaney/spark,holdenk/spark,szhem/spark,esi-mineset/spark,liutang123/spark,zuotingbing/spark,poffuomo/spark,JoshRosen/spark,akopich/spark,huang1900/spark,ioana-delaney/spark,andrewor14/spark,spark-test/spark,1haodian/spark,liyichao/spark,bdrillard/spark,caneGuy/spark,shaneknapp/spark,dongjoon-hyun/spark,aosagie/spark,jrshust/spark,lxsmnv/spark,zhouyejoe/spark,zzcclp/spark,zero323/spark,patrick-nicholson/spark,shubhamchopra/spark,lxsmnv/spark,ueshin/apache-spark,kissmetrics/spark,shuangshuangwang/spark,shuangshuangwang/spark,kiszk/spark,WindCanDie/spark,eyalfa/spark,janewangfb/spark,joseph-torres/spark,publicRoman/spark,kiszk/spark,wzhfy/spark,guoxiaolongzte/spark,spark-test/spark,ahnqirage/spark,tejasapatil/spark,hvanhovell/spark,loneknightpy/spark,bdrillard/spark,sachintyagi22/spark,saltstar/spark,adrian-ionescu/apache-spark,skonto/spark,goldmedal/spark,hhbyyh/spark,hvanhovell/spark,shubhamchopra/spark,JoshRosen/spark,ajaysaini725/spark,ueshin/apache-spark,map222/spark,mike0sv/spark,map222/spark,markhamstra/spark,dhruve/spark,big-pegasus/spark,hhbyyh/spark,aokolnychyi/spark,mike0sv/spark,mzl9039/spark,minixalpha/spark,actuaryzhang/spark,aray/spark,tengpeng/spark,bdrillard/spark,hhbyyh/spark,michalsenkyr/spark,publicRoman/spark,mdespriee/spark,esi-mineset/spark,dbtsai/spark,milliman/spark,dbtsai/spark,WeichenXu123/spark,saltstar/spark,aosagie/spark,eyalfa/spark,techaddict/spark,jiangxb1987/spark,big-pegasus/spark,lxsmnv/spark,bOOm-X/spark,dongjoon-hyun/spark,xflin/spark,HyukjinKwon/spark,aosagie/spark,skonto/spark,yanboliang/spark,sachintyagi22/spark,kimoonkim/spark,icexelloss/spark,kevinyu98/spark,rikima/spark,patrick-nicholson/spark,milliman/spark,nilsgrabbert/spark,chuckchen/spark,taroplus/spark,techaddict/spark,stanzhai/spark,SHASHANKB/spark,liutang123/spark,techaddict/spark,gengliangwang/spark,nchammas/spark,jkbradley/spark,jrshust/spark,ueshin/apache-spark,kimoonkim/spark,kevinyu98/spark,ibm-research-ireland/sparkoscope,xuanyuanking/spark,BryanCutler/spark,nilsgrabbert/spark,ron8hu/spark,wangyum/spark,MLnick/spark,mahak/spark,apache/spark,facaiy/spark,pgandhi999/spark,andrewor14/spark,nilsgrabbert/spark,pgandhi999/spark,chuckchen/spark,JoshRosen/spark,tengpeng/spark,wangyum/spark,ron8hu/spark,MLnick/spark,UndeadBaneGitHub/spark,szhem/spark,caneGuy/spark,lvdongr/spark,ahnqirage/spark,ibm-research-ireland/sparkoscope,mzl9039/spark,BryanCutler/spark,minixalpha/spark,liutang123/spark,darionyaphet/spark,wzhfy/spark,someorz/spark,dbtsai/spark,byakuinss/spark,apache-spark-on-k8s/spark,HyukjinKwon/spark,ibm-research-ireland/sparkoscope,wangyum/spark,sureshthalamati/spark,mike0sv/spark,aokolnychyi/spark,setjet/spark,dhruve/spark,ron8hu/spark,metamx/spark,Aegeaner/spark,liyichao/spark,tejasapatil/spark,akopich/spark,caneGuy/spark,UndeadBaneGitHub/spark,1haodian/spark,Panos-Bletsos/spark-cost-model-optimizer,jrshust/spark,UndeadBaneGitHub/spark,liyichao/spark,alunarbeach/spark,aray/spark,kissmetrics/spark,ptkool/spark,zzcclp/spark,JoshRosen/spark,apache/spark,HyukjinKwon/spark,wangyum/spark,goldmedal/spark,spark-test/spark,nlalevee/spark,joseph-torres/spark,sureshthalamati/spark,ddna1021/spark,liyichao/spark,MLnick/spark,apache-spark-on-k8s/spark,shubhamchopra/spark,xuanyuanking/spark,byakuinss/spark,michalsenkyr/spark,aokolnychyi/spark,mdespriee/spark,jrshust/spark,zhouyejoe/spark,gengliangwang/spark,zuotingbing/spark,JoshRosen/spark,ConeyLiu/spark,rekhajoshm/spark,eyalfa/spark,UndeadBaneGitHub/spark,aosagie/spark,actuaryzhang/spark,alunarbeach/spark,janewangfb/spark,witgo/spark,poffuomo/spark,ibm-research-ireland/sparkoscope,facaiy/spark,narahari92/spark,map222/spark,kimoonkim/spark,SHASHANKB/spark,rezasafi/spark,WindCanDie/spark,ConeyLiu/spark,chuckchen/spark,saltstar/spark,metamx/spark,zero323/spark,highfei2011/spark,rednaxelafx/apache-spark,mzl9039/spark,liyichao/spark,map222/spark,markhamstra/spark,milliman/spark,jlopezmalla/spark,actuaryzhang/spark,facaiy/spark,shuangshuangwang/spark,sahilTakiar/spark,aosagie/spark,adrian-ionescu/apache-spark,apache/spark,minixalpha/spark,SnappyDataInc/spark,JerryLead/spark,pgandhi999/spark,dongjoon-hyun/spark,goldmedal/spark,bravo-zhang/spark,michalsenkyr/spark,rikima/spark,brad-kaiser/spark,BryanCutler/spark,adrian-ionescu/apache-spark,bdrillard/spark,holdenk/spark,esi-mineset/spark,szhem/spark,nilsgrabbert/spark,publicRoman/spark,actuaryzhang/spark,bravo-zhang/spark,skonto/spark,milliman/spark,someorz/spark,ajaysaini725/spark,alunarbeach/spark,ericvandenbergfb/spark,pgandhi999/spark,poffuomo/spark,sachintyagi22/spark,jlopezmalla/spark,WeichenXu123/spark,JerryLead/spark,kissmetrics/spark,tejasapatil/spark,ajaysaini725/spark,kimoonkim/spark,maropu/spark,byakuinss/spark,panfengfeng/spark,SHASHANKB/spark,holdenk/spark,SnappyDataInc/spark,wzhfy/spark,liutang123/spark,zero323/spark,saturday-shi/spark,aray/spark,ConeyLiu/spark,nlalevee/spark,ahnqirage/spark,dongjoon-hyun/spark,byakuinss/spark,yanboliang/spark,aokolnychyi/spark,publicRoman/spark,wangyum/spark,ajaysaini725/spark,srowen/spark,lvdongr/spark,hvanhovell/spark,narahari92/spark,tengpeng/spark,wangmiao1981/spark,WeichenXu123/spark,ericvandenbergfb/spark,saltstar/spark,LantaoJin/spark,bOOm-X/spark,ahnqirage/spark,wzhfy/spark,highfei2011/spark,aokolnychyi/spark,spark-test/spark,nilsgrabbert/spark,goldmedal/spark,gengliangwang/spark,bravo-zhang/spark,skonto/spark,narahari92/spark,maropu/spark,LantaoJin/spark,rednaxelafx/apache-spark,ahnqirage/spark,ibm-research-ireland/sparkoscope,xflin/spark,tengpeng/spark,ioana-delaney/spark,techaddict/spark,ron8hu/spark,hvanhovell/spark,apache-spark-on-k8s/spark,map222/spark,markhamstra/spark,nchammas/spark,metamx/spark,MLnick/spark,szhem/spark,rekhajoshm/spark,kissmetrics/spark,jkbradley/spark,facaiy/spark,bravo-zhang/spark,jkbradley/spark,MLnick/spark,bOOm-X/spark,kevinyu98/spark,nchammas/spark,map222/spark,jiangxb1987/spark,1haodian/spark,shaneknapp/spark,dhruve/spark,icexelloss/spark,nlalevee/spark,andrewor14/spark,dongjoon-hyun/spark,someorz/spark,setjet/spark,andrewor14/spark,UndeadBaneGitHub/spark,darionyaphet/spark,ajaysaini725/spark,nlalevee/spark,debugger87/spark,WeichenXu123/spark,jianran/spark,HyukjinKwon/spark,ptkool/spark,lxsmnv/spark,yanboliang/spark,kiszk/spark,shaneknapp/spark,patrick-nicholson/spark,xflin/spark,SHASHANKB/spark,wangmiao1981/spark,darionyaphet/spark,akopich/spark,poffuomo/spark,darionyaphet/spark,witgo/spark,sahilTakiar/spark,Aegeaner/spark,mdespriee/spark,tejasapatil/spark,lvdongr/spark,nchammas/spark,cloud-fan/spark,witgo/spark,esi-mineset/spark,adrian-ionescu/apache-spark,goldmedal/spark,taroplus/spark,dbtsai/spark,bravo-zhang/spark,cloud-fan/spark,aray/spark,aokolnychyi/spark,HyukjinKwon/spark,minixalpha/spark,big-pegasus/spark,stanzhai/spark,gengliangwang/spark,akopich/spark,debugger87/spark,icexelloss/spark,apache/spark,stanzhai/spark,vinodkc/spark,janewangfb/spark,joseph-torres/spark,zero323/spark,icexelloss/spark,sureshthalamati/spark,HyukjinKwon/spark,sahilTakiar/spark,big-pegasus/spark,zzcclp/spark,minixalpha/spark,holdenk/spark,zhouyejoe/spark,jlopezmalla/spark,rikima/spark,kimoonkim/spark,narahari92/spark,huang1900/spark,guoxiaolongzte/spark,sahilTakiar/spark,ueshin/apache-spark,Aegeaner/spark,metamx/spark,lxsmnv/spark,Panos-Bletsos/spark-cost-model-optimizer,xflin/spark,UndeadBaneGitHub/spark,UndeadBaneGitHub/spark,Aegeaner/spark,ConeyLiu/spark,cin/spark,rednaxelafx/apache-spark,matthewfranglen/spark,WindCanDie/spark,mzl9039/spark,HyukjinKwon/spark,rekhajoshm/spark,andrewor14/spark,lvdongr/spark,wangyum/spark,witgo/spark,debugger87/spark,brad-kaiser/spark,sureshthalamati/spark,shaneknapp/spark,lxsmnv/spark,akopich/spark,someorz/spark,kevinyu98/spark,rezasafi/spark,cin/spark,wangmiao1981/spark,caneGuy/spark,MLnick/spark,holdenk/spark,saturday-shi/spark,dhruve/spark,kiszk/spark,saturday-shi/spark,bOOm-X/spark,sureshthalamati/spark,stanzhai/spark,setjet/spark,publicRoman/spark,jkbradley/spark,saturday-shi/spark,markhamstra/spark,xflin/spark,esi-mineset/spark,saturday-shi/spark,szhem/spark,huang1900/spark,brad-kaiser/spark,cloud-fan/spark,bOOm-X/spark,esi-mineset/spark,zhouyejoe/spark,ptkool/spark,SnappyDataInc/spark,lvdongr/spark,pgandhi999/spark,cin/spark,taroplus/spark,wzhfy/spark,pgandhi999/spark,ajaysaini725/spark,jiangxb1987/spark,sahilTakiar/spark,saturday-shi/spark,vinodkc/spark,jlopezmalla/spark,cin/spark,debugger87/spark,LantaoJin/spark,cloud-fan/spark,liyichao/spark,jianran/spark,patrick-nicholson/spark,guoxiaolongzte/spark,tengpeng/spark,janewangfb/spark,maropu/spark,xflin/spark,LantaoJin/spark,1haodian/spark,shubhamchopra/spark,publicRoman/spark,zhouyejoe/spark,ron8hu/spark,liutang123/spark,highfei2011/spark,xuanyuanking/spark,taroplus/spark,narahari92/spark,hhbyyh/spark,dhruve/spark,apache-spark-on-k8s/spark,michalsenkyr/spark,SnappyDataInc/spark,nlalevee/spark,jrshust/spark,nlalevee/spark,ahnqirage/spark,mdespriee/spark,eyalfa/spark,shuangshuangwang/spark,mdespriee/spark,zzcclp/spark,byakuinss/spark,ioana-delaney/spark,actuaryzhang/spark,michalsenkyr/spark,SHASHANKB/spark,BryanCutler/spark,SHASHANKB/spark,shuangshuangwang/spark,chuckchen/spark,holdenk/spark,darionyaphet/spark,techaddict/spark,jlopezmalla/spark,dongjoon-hyun/spark,shaneknapp/spark,jlopezmalla/spark,mdespriee/spark,kimoonkim/spark,LantaoJin/spark,JerryLead/spark,icexelloss/spark,SnappyDataInc/spark,big-pegasus/spark,guoxiaolongzte/spark,tengpeng/spark,andrewor14/spark,SnappyDataInc/spark,ddna1021/spark,yanboliang/spark,mzl9039/spark,WindCanDie/spark,alunarbeach/spark,highfei2011/spark,huang1900/spark,facaiy/spark,Aegeaner/spark,cloud-fan/spark,ConeyLiu/spark,JerryLead/spark,markhamstra/spark,shaneknapp/spark,saltstar/spark,WeichenXu123/spark,minixalpha/spark,debugger87/spark,caneGuy/spark,mzl9039/spark,ueshin/apache-spark,jrshust/spark,tengpeng/spark,brad-kaiser/spark,sahilTakiar/spark,witgo/spark,minixalpha/spark,bravo-zhang/spark,byakuinss/spark,ericvandenbergfb/spark,bdrillard/spark,loneknightpy/spark,lvdongr/spark,jianran/spark,eyalfa/spark,highfei2011/spark,rednaxelafx/apache-spark,liutang123/spark,mahak/spark,wangmiao1981/spark,guoxiaolongzte/spark,metamx/spark,Panos-Bletsos/spark-cost-model-optimizer,SHASHANKB/spark,nilsgrabbert/spark,alunarbeach/spark,Panos-Bletsos/spark-cost-model-optimizer,ericvandenbergfb/spark,WindCanDie/spark,dhruve/spark,icexelloss/spark,jianran/spark,tejasapatil/spark,wangmiao1981/spark,setjet/spark,spark-test/spark,srowen/spark,ConeyLiu/spark,mahak/spark,someorz/spark,ioana-delaney/spark,huang1900/spark,ibm-research-ireland/sparkoscope,akopich/spark,aray/spark,zuotingbing/spark,skonto/spark,1haodian/spark,eyalfa/spark,zhouyejoe/spark,holdenk/spark,milliman/spark,big-pegasus/spark,huang1900/spark,jkbradley/spark,poffuomo/spark,Panos-Bletsos/spark-cost-model-optimizer,dbtsai/spark,caneGuy/spark,jiangxb1987/spark,bOOm-X/spark,witgo/spark,techaddict/spark,bravo-zhang/spark,facaiy/spark,taroplus/spark,BryanCutler/spark,metamx/spark,cin/spark,ptkool/spark,dhruve/spark,saturday-shi/spark,loneknightpy/spark,cloud-fan/spark,BryanCutler/spark,xuanyuanking/spark,brad-kaiser/spark,adrian-ionescu/apache-spark,Aegeaner/spark,someorz/spark,ron8hu/spark,jianran/spark,ddna1021/spark,ddna1021/spark,cin/spark,panfengfeng/spark,poffuomo/spark,rekhajoshm/spark,metamx/spark,MLnick/spark,ron8hu/spark,apache-spark-on-k8s/spark,JerryLead/spark,darionyaphet/spark,rezasafi/spark,loneknightpy/spark,brad-kaiser/spark,sachintyagi22/spark,szhem/spark,kissmetrics/spark,zuotingbing/spark,mike0sv/spark,guoxiaolongzte/spark,rezasafi/spark,bOOm-X/spark,stanzhai/spark,Panos-Bletsos/spark-cost-model-optimizer,mahak/spark,shubhamchopra/spark,setjet/spark,spark-test/spark,patrick-nicholson/spark,apache/spark,apache-spark-on-k8s/spark,ajaysaini725/spark,yanboliang/spark,jlopezmalla/spark,apache/spark,witgo/spark,facaiy/spark,1haodian/spark,skonto/spark,WeichenXu123/spark,mike0sv/spark