Where to see the polybase rejected rows? In other words what is the location of the rejected rows?


suppose loaded 2000 rows , 4 rejected polybase. these 4 rows can located? logged somewhere default or settings need change?

vgangal

hi,

unfortunately, not possible far. can find answer microsoft in post https://social.msdn.microsoft.com/forums/sqlserver/en-us/d31dd9d7-f1e1-4367-bdab-a7efb17a3c04/solution-to-log-polybase-rejected-rows-to-file-or-table?forum=azuresqldatawarehouse

also, can vote feature on feedback site https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/9892620-polybase-allow-retrieving-rejected-rows-in-an-err

sergiy lunyakin (data platfrom mvp)



Microsoft Azure  >  Azure SQL Data Warehouse



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

job syspolicy_purge_history job fail in sqlserver 2008

Image
hello guys, when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history. but failed @ step 1. the reason is: date                11/6/2010 2:00:00 am log                job history (syspolicy_purge_history) step id                1 server                mxosv-otsdb01 job name                syspolicy_purge_history step name                verify automation enabled. duration                00:00:00 sql severity                16 sql message id                34022 operator emailed                operator net sent                operator paged                retries attempted                0 message executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022).  the step failed. have run statement: select msdb.dbo.fn_syspolicy_is_automation_enabled the returned valus 0. what can resolve it? or can delete job manually.   thanks in advance. if haven't things want,be
Read more

how to make datagridview combobox editable in c#

Image
hello all, i using c#.net create windows application, here use datagridview add new details , use combobox datagridview combobox coloum select items , want add new item here. i aslo set datasoure for datagridview coloum bind data base, i want edit datagridview combobox coloum, here color column want add new color cant , restrict enter number on column here design here code add datagridview combobox coloum on load               datagridviewcomboboxcolumn cmb1 = new datagridviewcomboboxcolumn();             cmb1.headertext = "color";             gvvd.columns.add(cmb1); private void gvvd_editingcontrolshowing(object sender, datagridvieweditingcontrolshowingeventargs e)         {             datagridviewcomboboxeditingcontrol combocontrol = e.control datagridviewcomboboxeditingcontrol;             if (combocontrol != null)             {                 //set dropdown style editable combobox                 if (combocontrol.dropdownstyle != combo
Read more